Percentage Increase Calculation

K

Karen

How do you show a 100% increase from one year's sales to the next when year 1
is zero?

The formula keeps showing the divided by zero error?
 
R

Ron Coderre

You couldn't multiply $0 by 100% and get the amount you're looking for.
Where I work....we report that increase as n.m. (not meaningful).

If that's your company's convention, though, something like this may be what
you're looking for:

=IF(A1=0,100%,B1/A1)

Does that help?

***********
Regards,
Ron
 
R

Rusty

Hi Karen,

What you are asking is mathematically impossible. When you divide any
number by zero you get infinity, so Excel correctly shows "divide by zero".

Look at it this way;
If cell A1 contains 1 and B1 contains 5 then the increase is 500%
If cell A1 contains 0.1 and B1 contains 5 then the increase is 5000%
If cell A1 contains 0.01 and B1 contains 5 then the increase is 50000%
The smaller the value in cell A1 the larger the answer. So by the time you
get down to zero in cell A1, the increase is infinity!

Cheers,
Ken
 
Top