Formula for percentage increase/decrease problem

  • Thread starter Thread starter chewie88
  • Start date Start date
C

chewie88

I am trying to get a percentage of increase or decrease in a cell. I a
running into a #DIV/0! error. The formula is =SUM(B68-B23)/B23 but B2
is a zero. I need to change the zero to a 1. What should it include "i
B23 is 0 than /1"? Please help. Thanks in advance
 
I would guess you need something like:

=IF(B23=0, B68, (B68-B23)/B23)

This would give you the value in cell B68 if the value of B23 is zero.

Alternatively, if you want the result to be 1:

=IF(B23=0, 1, (B68-B23)/B23)

Or zero:

=IF(B23=0, 0, (B68-B23)/B23)

Not quite sure what you want to get

Regards

Trevor
 
.... and here's my two cents: =IF(B23=0,(B68-B23)/1,(B68-B23)/B23).

So if B68=1 and B23=0 the result shows we have a 100% increase (over
nothing).
 
Back
Top