Calculating the difference between 2 percentages (Ratios)

  • Thread starter Thread starter Stilltrader47
  • Start date Start date
S

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
 
Stilltrader47 said:
for example:
18.40 / -28.27
expressed as a ratio the result should be: 1.65
Click to expand...

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 -----
 
Back
Top