Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to calculate % difference when actual 1, budget -48
need help to work out above formula
|
#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 |
Reply |
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 |