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? |
Negative numbers in easy formula getting me down...
You can multiply your result by a -1 to insure that it's positive.
=((H33-N33)/N33)*-1 or =IF((H33-N33)/N33<0,((H33-N33)/N33)*-1,=(H33-N33)/N33) -- Kevin Backmann "jennieoh" wrote: 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? |
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 |
Negative numbers in easy formula getting me down...
how about
=(H33-N33)/abs(N33) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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? |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com