Percentage between two numbers
Hi, i have this two situations:
2394 34 -98,58%
34 2394 6941,18%
This is the formulas i used:
=(B1-A1)/ABS(A1)
=(B2-A2)/ABS(A2)
I need a formula to calculate the percentage of differences between two
numbers even if the first is bigger than the second or the other way around.
This is how i need the final result to look:
2394 34 -98,58%
34 2394 +98,58%
Can this be done?
Thanks!
|