If you divide by the maximum you'll get your 98.58%; if you divide by the
minimum you'll get the 6941.18%.
--
David Biddulph


"puiuluipui" wrote in message
...
Hi, your formula result was:
2394 34 -98,58%
34 2394 +98,58%

Can a formula like this make the result look like this?
2394 34 -6941,18%
34 2394 +6941,18%

Can this be done?
Thanks!




"Rik_UK" wrote:

You could try the following formula instead...

=IF(A2B2,(B2-A2)/ABS(A2),ABS((A2-B2)/ABS(B2)))

and then set the custom format to +0,00%;-0,00%

Best of luck

"puiuluipui" wrote:

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!