Percentage Difference Between Budget & Actual
 

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

Answer: Percentage Difference Between Budget & Actual
 

To calculate the percentage difference between budget and actual:

1. Subtract the budget from the actual amount in a new cell.
   
   Formula:

   ---

   =Actual-Budget 


   ---

2. Divide the result by the budget amount.
   
   Formula:

   ---

   =(Actual-Budget)/Budget 


   ---

3. Multiply the result by 100 to get the percentage difference.
   
   Formula:

   ---

   =(Actual-Budget)/Budget*100 


   ---

To increase the previous year to the current year:

1. Subtract the previous year amount from the current year amount in a new cell.
   
   Formula:

   ---

   =Current Year-Previous Year 


   ---

2. Divide the result by the previous year amount.
   
   Formula:

   ---

   =(Current Year-Previous Year)/Previous Year 


   ---

3. Multiply the result by 100 to get the percentage increase.
   
   Formula:

   ---

   =(Current Year-Previous Year)/Previous Year*100 


   ---

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.