Percentage Difference Between Budget & Actual
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
"Cheer Fever" wrote:
I am trying to get get the percentage difference between budget and actual.
And Also increase previous year to current year.
|