molsviking
New Member
- Joined
- Jan 24, 2019
- Messages
- 6
An interesting conundrum:
C9 has a figure which could be positive or negative.
H9 also has a figure which could be positive or negative.
If both figures in C9 & H9 are postive, then the variance in K9 with the following formula would return a positive variance: =IF(ISERROR((C9-H9)/H9),"N/A",(C9-H9)/H9)
However
If both figures in C9 & H9 are negative, then the variance in K9 would still show a positive variance. How can i amend the formula in K9 to show me a Negative figure instead of a positive one?
ie: C9 = -114,422
H9 = -22484
K9 = -408.9%
C9 has a figure which could be positive or negative.
H9 also has a figure which could be positive or negative.
If both figures in C9 & H9 are postive, then the variance in K9 with the following formula would return a positive variance: =IF(ISERROR((C9-H9)/H9),"N/A",(C9-H9)/H9)
However
If both figures in C9 & H9 are negative, then the variance in K9 would still show a positive variance. How can i amend the formula in K9 to show me a Negative figure instead of a positive one?
ie: C9 = -114,422
H9 = -22484
K9 = -408.9%