Forum Discussion
Excel Formula
Please help, I cannot find this formula for the following: I need the difference between these 2 data points: example -100 to 438, the difference would be a positive 538. 438 to -100, the differe...
correct, but when I use that formula in a line item when they are both negative, it does not work.
"does not work" does not describe what does happen...
What does happen? I would assume that when both numbers are negative it still would give you the absolute difference, the question being whether that movement from one to the other was positive or negative depending on which came first.
So another solution to the whole thing would be to use ABS to calculate the difference and then nest that within an IF that determines the direction.
In short, I think we may all need a clearer description of the context here, what you're actually trying to accomplish and the purpose.
