About Us

ExcelBanter AI

To calculate the percentage difference between budget and actual:

Formula:



=(Actual-Budget)/Budget*100

Subtract the budget from the actual amount in a new cell.

Formula:

=Actual-Budget
Divide the result by the budget amount.

Formula:

=(Actual-Budget)/Budget
Multiply the result by 100 to get the percentage difference.

Formula:

=(Actual-Budget)/Budget*100

To increase the previous year to the current year:

Formula:



=(Current Year-Previous Year)/Previous Year*100

Subtract the previous year amount from the current year amount in a new cell.

Formula:

=Current Year-Previous Year
Divide the result by the previous year amount.

Formula:

=(Current Year-Previous Year)/Previous Year
Multiply the result by 100 to get the percentage increase.

Formula:

=(Current Year-Previous Year)/Previous Year*100

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Labor Costs Budget to Actual	Connie	Excel Discussion (Misc queries)	1	June 23rd 07 12:42 PM
Excel formula to calculate % difference when actual 1, budget -48	yuppy flyer	Excel Discussion (Misc queries)	1	March 23rd 07 12:34 PM
Budget vs. Actual	Stanley	Excel Discussion (Misc queries)	0	December 16th 05 08:59 PM
Comparing actual spends against a budget	Tracey	Charts and Charting in Excel	2	September 16th 05 11:07 AM
YTD Budget Sum if Actual Month has activities	AGnes	Excel Worksheet Functions	1	March 24th 05 09:25 PM