A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...

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 ...