Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could someone tell me the difference in these formulas?
(+Budget/Actual)-1
((Actual - Budget)/Budget) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could someone tell me the difference in these formulas?
This is not an excel question, but here is the answer
(+Budget/Actual)-1 Budget Actual = -------- - -------- Actual Actual Budget - Actual = ---------------- Actual ((Actual - Budget)/Budget) Actual - Budget = ---------------- Budget Do you see it now??? "Mel" wrote in message ... (+Budget/Actual)-1 ((Actual - Budget)/Budget) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could someone tell me the difference in these formulas?
"Mel" wrote:
(+Budget/Actual)-1 ((Actual - Budget)/Budget) The first formula is effectively (budget-actual)/actual. Conversely, the second formula is effectively (actual/budget)-1. Now you can see the difference. The first formula is the percentage difference between "budget" over "actual". The second formula is the percentage difference between "actual" over "budget". The second formual is typically what want in this context. It answers the question: "what percentage over-budget are we?". But if you change the names, both formulas might be equally valid, depending on what you want. For example, if "budget" is "myDistance" and "annual" is "yourDistance", the first formula answers the question: "what percentage more (or less) did I travel?"; and the second formula answers the question: "what percentage more (or less) did you travel?". HTH. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |