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
 
Top