calculating growth percentage?

[phil]

I'm trying to figure out how to calculate growth percentage, if one of the
numbers is negative.

i.e.:
Last year's EPS = -0.394
This year's EPS = 0.84

I'd like a formula that returned a correct growth percentage if both numbers
were positive as well. Is there one formula that will return the correct
growth percentage in either case?

Thanks!

 

[Ken Russell]

=IF(B2<0,+(C2/B2-1)*-1,C2/B2-1)

Ken Russell
Remove hat to reply by e-mail
(e-mail address removed)

| I'm trying to figure out how to calculate growth percentage, if one of the
| numbers is negative.
|
| i.e.:
| Last year's EPS = -0.394
| This year's EPS = 0.84
|
| I'd like a formula that returned a correct growth percentage if both
numbers
| were positive as well. Is there one formula that will return the correct
| growth percentage in either case?
|
| Thanks!
| ---
| Phil
|
|

 

[Bill Kuunders]

Phil
one way is.............
a1=last year
a2=this year
in a3 enter =(a2-a1)/abs(a1/100)

Regards
Bill K