Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a formula to add a percentage
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 -- Jill |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a formula to add a percentage
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" wrote: 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 -- Jill |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a formula to add a percentage
Jill,
Try this =MROUND(A1*1.05,1) If you get a #Name error then Tools|Addins Check the analysis toolpak. Mike "Jill" wrote: 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 -- Jill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help - formula for percentage | Excel Worksheet Functions | |||
IF formula & Percentage | Excel Discussion (Misc queries) | |||
IF formula & Percentage | Excel Discussion (Misc queries) | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
Percentage Formula | Excel Worksheet Functions |