Is there a formula to add a percentage

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

I am not very good at formulas. I am hoping there is a formula that can do
what I want. I have a column of numbers, I want the whole column of numbers
to increase by 5%. Then I would like to be able to take that formula and
copy and paste to many other columns on many spreadsheets. I have pricing
sheets in excel and I need to increase all prices by 5% and I am looking for
an easy way to do this. Can someone help?

904 Need to increase this number by 5%, and have 950 show up in the same cell
947
940
and so on
 
Sure thing.

In a blank cell, enter 1.05. Copy yhat cell, then highlight all of the
desired cells.

Right-click and select paste special...

Select multiply.

all highlighted cells will bemultiplied by 1.05, or increased by 5%.
 
Jill,

Try this
=MROUND(A1*1.05,1)
If you get a #Name error then
Tools|Addins
Check the analysis toolpak.

Mike
 
Back
Top