View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.