Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the difference between 2 percentages (Ratios)
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the difference between 2 percentages (Ratios)
"Stilltrader47" wrote:
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 ----- "Stilltrader47" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating ratios: Is there a formula that can do this? | Excel Worksheet Functions | |||
Excel Help Please Ratios & Percentages | Excel Discussion (Misc queries) | |||
Excel Help Please Ratios & Percentages | Excel Discussion (Misc queries) | |||
Excel Help Please Ratios & Percentages | Excel Discussion (Misc queries) | |||
Excel Help Please Ratios & Percentages | Excel Discussion (Misc queries) |