Negative numbers in easy formula getting me down...
I'm using a formula to calculate the % increase or decrease of some numbers.
My formula is =(H33-N33)/N33. However, I have a negative number N33 so the %
should be a positive because there was an increase but it's coming out a
negative. Why isn't this calculating N33 as a negative number?
|