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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNT question 3
IF 1
Adding up Sums 3
percentage in brackets 2
conditional formulas 2
Countif for 2 columns 3
calculate average from non contiguous column, ignoring (0) values 3
Negative numbers 4

Back
Top