how can i raise row of list prices to 10% higher

M

mowerman

at our store we have price sheets in excell and i want to raise the list
prices all at one time to 10% higher . can i do this and how
 
R

Ron Coderre

Try this:

Enter 1.1 in a blank cell
Edit>Copy

Select your range containing current prices
Edit>Paste Special>
Check: Values
Check: Multiply
Click the [OK] button

That should do it!

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
K

Ken Wright

Do you want to lose the existing values?

1) Keeping existing values, simply use another column and use a formula such
as =A2*1.1 and copy down.

2) Replacing existing values, put 1.1 in any empty cell, then copy that
cell. Select all your values and then do edit / paste special / values &
multiply

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
G

Gary''s Student

1. Put 1.1 in an un-used cell and copy the cell
2. Select all the cells you want to increase and then paste/special with the
multiply botton set
 
M

mowerman

thanks for the tip , it worked perfect!

Ken Wright said:
Do you want to lose the existing values?

1) Keeping existing values, simply use another column and use a formula such
as =A2*1.1 and copy down.

2) Replacing existing values, put 1.1 in any empty cell, then copy that
cell. Select all your values and then do edit / paste special / values &
multiply

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
Click to expand...
 
M

mowerman

thanks for the tip it worked perfect

Gary''s Student said:
1. Put 1.1 in an un-used cell and copy the cell
2. Select all the cells you want to increase and then paste/special with the
multiply botton set
Click to expand...
 
M

mowerman

thanks for the tip it worked perfect

Ron Coderre said:
Try this:

Enter 1.1 in a blank cell
Edit>Copy

Select your range containing current prices
Edit>Paste Special>
Check: Values
Check: Multiply
Click the [OK] button

That should do it!

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


mowerman said:
at our store we have price sheets in excell and i want to raise the list
prices all at one time to 10% higher . can i do this and how
Click to expand...
Click to expand...
 
Top