Stop #DIV/0! Errors in Excel

by on July 14, 2009

Q: I’m Using Microsoft Office Excel 2007 workbook. I’m trying to calculate the sales growth percentage from the months of Jan 2009 and Feb 2009. I can’t seem to get a formula that is working. I thought I had one but in Jan 2009 some companies didn’t use us and in Feb 2009 they used 35 dollars worth. When I use this formula I get #DIV/0! pops up. How do I stop this?

A: What you need to do is modify your formula to check if the divisor is 0. So you would do something like =IF(A2=0, 0, A1/A2). This will put 0 in the cell instead of the #DIV/0! error and should allow you to sum your cells up correctly.

Read Question Here