1] Use formula suggestions or Function Wizard to avoid syntax errors Microsoft Excel displays a list of matching formulas as soon as you start typing the function in the function bar.

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...

Sean Duffy – the founder of Excel Everest says – "Research shows that 94 percent of professional spreadsheets contain errors. The cost of such errors is vastly underestimated.

What's unusual here is that someone checked it," says Ray Panko, a professor at the University of Hawaii and the elder statesman of small coterie of research academics who study—yes—Excel errors.