View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Negative numbers in easy formula getting me down...

"jennieoh" wrote in message
...
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?


You could use =(H33-N33)/ABS(N33), but bear in mind the possibility of N33
being zero (in which case you'd need to think about what % increase you'd
want to show there).
--
David Biddulph