No, if you start with 0, the formula

=IF(B1<0, C1/B1-1,"N/A")

will return "N/A", because the % increase is, by definition, undefined.

It's not 400%, because

2006 = 0.8
2007 = 4

is a 400% increase (e.g., 0.8 + 4*0.8).

Put another way, what number would you multiply by zero to get 4? That
(if it existed) would be the % increase...


In article ,
dj479794 wrote:

Your formula works. Thanks. One concern. when there is data like:

2006 = 0
2007 = 4

It shows an increase of 100%. Should it not be 400% assuming all data must
be a whole number.