Formula for percentage increase/decrease problem

[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

 

[Trevor Shuttleworth]

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

 

[chewie88]

thanks that actually got it

 

[DDM]

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

 

[chewie88]

thanks that actually got it