Percentage Difference Between Budget & Actual

  • Thread starter Thread starter Cheer Fever
  • Start date Start date
C

Cheer Fever

I am trying to get get the percentage difference between budget and actual.
And Also increase previous year to current year.
 
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

Change all of the cells in a row(s) by a percentage 4
Formulas 2
Need help with if(and formula.. 6
Formula for concatenating text with results from calculation 2
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Cell formatting 4
how do i calculate percentage of change between two or more field. 3
Pivot Tables - Grand Totals 2

Back
Top