|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2008, 01:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
precentage formula
I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a
formula that will tell me what the precentage is for the difference between both amounts 
|
|
#2
August 6th, 2008, 02:02 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
precentage formula
Percentage of what?
i.e.: Suppose your two values are in A1, and A2 A3: =ABS(A1-A2)/A2 or A3: =ABS(A1-A2)/A1 percent difference between two of 33658.60 ~ 33.25% percent difference between two of 44850.00 ~ 24.95% -- John C "Dphel" wrote: I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a formula that will tell me what the precentage is for the difference between both amounts
|
|
#3
August 6th, 2008, 03:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
precentage formula
Why have you used ABS?
Surely one needs to know if the change is an increase or a decrease? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "John C" johnc@stateofdenial wrote in message ... Percentage of what? i.e.: Suppose your two values are in A1, and A2 A3: =ABS(A1-A2)/A2 or A3: =ABS(A1-A2)/A1 percent difference between two of 33658.60 ~ 33.25% percent difference between two of 44850.00 ~ 24.95% -- John C "Dphel" wrote: I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a formula that will tell me what the precentage is for the difference between both amounts
|
|
#4
August 6th, 2008, 05:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
precentage formula
Asked for the percent difference. If someone says, give me the percentage
difference from 8 to 10, I'll say 25%. Conversely, if someone says give me the percentage difference from 10 to 8, I'll say 20%, not negative 20%. Just my 2 cents. -- John C "Bernard Liengme" wrote: Why have you used ABS? Surely one needs to know if the change is an increase or a decrease? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "John C" johnc@stateofdenial wrote in message ... Percentage of what? i.e.: Suppose your two values are in A1, and A2 A3: =ABS(A1-A2)/A2 or A3: =ABS(A1-A2)/A1 percent difference between two of 33658.60 ~ 33.25% percent difference between two of 44850.00 ~ 24.95% -- John C "Dphel" wrote: I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a formula that will tell me what the precentage is for the difference between both amounts
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
