Change Percentage DIV/0! Error

A

ajpowers

I'm trying to see the change between (A) 2002 unit sales and (B)200
unit sales, and am using the following formula:

=(B-A)/A

This gives me the difference negative or positive, however if A (200
sales) is zero, then I get the DIV/0! error, how do I fix this?

Thank you
 
M

mzehr

Hi,
A couple of things you might want to consider. One is
that your formula will not take into account what the
change is if the prior month base amount is negative. To
fix that use the =IF(base=0,"",(current-base)/ABS(base))

This should help
 
C

cincode5

ajpowers,

You can also modify the existing formula to read as such:
=(B-A)/((A+.0000000001)
 
L

Llobid

Hi...

Your problem is not with your formula...it's with your math. You can'
find a percent increase or decrease of a zero value. Try using
modified formula.

=IF(A1=0,"N.A.",(B1-A1)/A1)

This will give you a proper percent increase or decrease in every cas
where it is mathematically possible
 
Top