Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Increase A2 by 15%
I have a worksheet with numbers in all cells. I would like to increase each
cells value by 15% and have the results stay in their original cell. I have done this before with a simple copy and special past, but now I can't figure it out. Thanks for any help. |
#2
|
|||
|
|||
First put 1.15 in an un-used cell.
Then select the cell and copy it. Then sellect all the cells you want to update and Paste Special with the multiply button checked. Each of the cells will then updated by +15% Have a good day! -- Gary's Student "Kellytwh" wrote: I have a worksheet with numbers in all cells. I would like to increase each cells value by 15% and have the results stay in their original cell. I have done this before with a simple copy and special past, but now I can't figure it out. Thanks for any help. |
#3
|
|||
|
|||
Thank You! I was using .15 instead of 1.15.
"Gary's Student" wrote: First put 1.15 in an un-used cell. Then select the cell and copy it. Then sellect all the cells you want to update and Paste Special with the multiply button checked. Each of the cells will then updated by +15% Have a good day! -- Gary's Student "Kellytwh" wrote: I have a worksheet with numbers in all cells. I would like to increase each cells value by 15% and have the results stay in their original cell. I have done this before with a simple copy and special past, but now I can't figure it out. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase by percentages | Excel Discussion (Misc queries) | |||
Percent increase | Excel Worksheet Functions | |||
Calculate a forecasted increase using a Absolute Ref | New Users to Excel | |||
How do I increase type size in an Excel drop down list? | Excel Discussion (Misc queries) | |||
calculate percent increase | Excel Discussion (Misc queries) |