Any excel experts out there...I have a question!

Re: Any excel experts out there...I have a question!

• Fordlor member

  January 2009

  yes, you should be able to create a formula to increase the value in each cell by 20%.  I would do it for you but I don't have excel on this computer.  I can't remember off hand how to do it though.  sorry! 

  

  Report0 Reply
• Loading the player...
• jennnick

  January 2009

  Say the figure you want to increase is in cell A1.  In a new column, insert =A1*1.20

   Then copy that down the entire new column and you should be good to go.

  

  Report0 Reply
• goodtobethelarkster member

  January 2009

  I think you can just write a new formula, highlight the column and apply the new formula to all of the prices in that column...

  Report0 Reply
• bunny731 member

  January 2009

  If your column starts at A1 then type in B1 = SUM(A1*1.2) and drag down until all the rows have a 20% increase.

  If you click into B2 you should see =SUM(A2*1.2)-Excel is smart when you drag equations.

  I hope this makes sense. You can hide the first column if you no longer need it, but you can't delete it since you needed it to build the equation.

  

  Report0 Reply
• tonysbride2b

  January 2009

  It worked, thank you all! 

  

  Report0 Reply