M
Muskoka83
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!
(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!