Percentages don't work that way. If your investment portfolio drops 50%
(from $10,000 to $5,000), you need a 100% increase to get back to your
starting position. Similarly, going from 2394 to 34 is a 98% decrease, but
to get from 34 back up to 2394, you need a 6941% increase. Your original
formulas are correct.

Regards,
Fred

"puiuluipui" wrote in message
...
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!