Hi,
I'm trying to calculate the signed difference between two numbers.
I'm wanting to show if the range between two numbers is positive and negative.
Evertime I calculate the difference between two numbers it always shows up as positive, even if the second number is less than the first.
For e.g.
55%
18%
diff: 37%, but I want it to show that it is -37%
Is there a formula that will adapt depending on whether the second number is bigger or smaller than the first?
Thanks.
I'm trying to calculate the signed difference between two numbers.
I'm wanting to show if the range between two numbers is positive and negative.
Evertime I calculate the difference between two numbers it always shows up as positive, even if the second number is less than the first.
For e.g.
55%
18%
diff: 37%, but I want it to show that it is -37%
Is there a formula that will adapt depending on whether the second number is bigger or smaller than the first?
Thanks.