Percentage Calcs
 

Trying to figure out the % difference(increase or decrease) between two #s
(A1 was last year, B1 is this year):
A1 = $65,902
B1 = $32,732

The way I did it was: IF(ISERROR((B1-A1)/B1),"--",(B1-A1)/B1)
which returns a value of: 101%

Which is wrong as it should be approximately 50%. I don't want to have to
change my formula in each row based on if last year was higher or lower than
this year...

Thanks!

Percentage Calcs
 

=IF(A1=0,"--",(B1-A1)/A1)
--
David Biddulph


"Muskoka83" wrote in message
...
Trying to figure out the % difference(increase or decrease) between two #s
(A1 was last year, B1 is this year):
A1 = $65,902
B1 = $32,732

The way I did it was: IF(ISERROR((B1-A1)/B1),"--",(B1-A1)/B1)
which returns a value of: 101%

Which is wrong as it should be approximately 50%. I don't want to have to
change my formula in each row based on if last year was higher or lower
than
this year...

Thanks!