Formulas in Excel XP

R

Rebecca

Trying to insert a 5% price increase into a range of cells. I.e. - customer
price list will recieve a 5% increase... Is there any way to to insert a
formula into a range of cells or do you "paste & copy" the formula into each
individual cell (what I am doing now).
 
S

Search33

Put the number 1.05 into a cell that you are not currently using. Copy the
cell. Highlight the range of cells that you would like to apply the 5%
increase to. Click on Edit --> Past Special... --> Choose Multiply from the
operation section. Click OK.
- Search
 
P

Peo Sjoblom

If you are going to increase a value with 5% you can do as follows,
put 1.05 in an empty cell, copy it (ctrl + C or edit>copy), select the list
you want to change and do edit>paste special and select multiply
You might want to backup your data first
 
R

Rebecca

Thank You - Thank You - Thank You

Search33 said:
Put the number 1.05 into a cell that you are not currently using. Copy the
cell. Highlight the range of cells that you would like to apply the 5%
increase to. Click on Edit --> Past Special... --> Choose Multiply from the
operation section. Click OK.
- Search
Click to expand...
 
R

Rebecca

Thank You so much!!

Peo Sjoblom said:
If you are going to increase a value with 5% you can do as follows,
put 1.05 in an empty cell, copy it (ctrl + C or edit>copy), select the list
you want to change and do edit>paste special and select multiply
You might want to backup your data first


--

Regards,

Peo Sjoblom
Click to expand...
 
Top