Calculating the difference between 2 percentages (Ratios)

[Stilltrader47]

I would like to express the percent difference change between 2 Ratios
(expressed as percents), and the divisor is negative. for example:

18.40 / -28.27

expressed as a ratio the result should be: 1.65

My calculation yields .65 which I know isn't correct.

Thanks for your help

Sony

 

[JoeU2004]

for example:
18.40 / -28.27
expressed as a ratio the result should be: 1.65

I'm not sure, but I think you want:

=(A2 - A1) / ABS(A1)

where A1 contains -28.27, and A2 contains 18.40.

Try the formula with different combinations of negative and positive numbers
to be sure it truly works for you. Your problem description is not clear
enough to me for me to be sure.

(I prefer to pairs of numbers where the expected results are obvious by
inspection, e.g. +/- 100 and zero.)


----- original message -----