| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to calculate % difference when actual 1, budget -48
If Actual is in A1, and budget in B1
The difference, how much actual exceeded budget, is (A1-B1) Percentage is nothing more that a ratio, the difference compared to the budget is =(A1-B1)/B1 Generally these are small numbers and since most people are uncomfortable with small numbers we used to multiply by 100 and call in percentage; in worksheets we just format as percentage. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "yuppy flyer" <yuppy wrote in message ... need help to work out above formula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to calculate time difference | New Users to Excel | |||
| Formulas calculate specified percentage of annual budget in Excel | Excel Worksheet Functions | |||
| Budget vs. Actual | Excel Discussion (Misc queries) | |||
| Comparing actual spends against a budget | Charts and Charting in Excel | |||
| YTD Budget Sum if Actual Month has activities | Excel Worksheet Functions | |||
Threaded Mode
