Excel Formula

  • Thread starter Thread starter Donne
  • Start date Start date
D

Donne

I have a spread sheet with 3 columns.

A)Has 2003 unit sales
B)Has 2002 unit sales
C)Column subtracts A-B/B to find the percentage of
increase or decrease from 2002 to 2003.

A(2003) B(2002) C(Difference)
Row(1) 2 1 100%
Row(2) 1 2 -50%
Row(3) 1 0 #DIV/0!

The issue I am having is the errow when column B has 0
sales. I get the following error in column C #DIV/0!

Any help would be appreciated.
 
Donne

If A is in column B and B is in Column C, then

=IF(C23=0,"",(B23-C23)/C23)

Regards
Peter
 
The answer ends up blank. If I sold 0 last year and 2
this year it should be a 200% increase.

Do you have any other suggestions?

I appreciate the help.

Donne
 
One could question the merit of doing this but you could try something like

=IF(B1=0,A1-B1,(A1-B1)/B1)
 
Back
Top