Percentage Difference Between Budget & Actual

C

Cheer Fever

I am trying to get get the percentage difference between budget and actual.
And Also increase previous year to current year.
 
S

Sheeloo

Assuming Budget in A1, Actual in B1, Previous Year Value in C1, Current Year
in D1

Then enter in E1
=(B1-A1)/A1*100 percentage difference between Actual and Budget (you may
swap A1 with B1 as you want the formula to be

Enter in F1
=(D1-C1)/C1*100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Budget Cost - Tracking 0
Work Budget Salary vs Real Time Salary 0
Power Pivot Variance Column 0
Pivot Table 2007 display field only in Grand Total 0
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Need help with if(and formula.. 6
Formulas 2
Percentage of month passed formula 1

Top