How do I add 10% to every number in a set of cells?

C

Colchabay

I want to add 10% to a current price list that I have. How can I select a
range of cells and add 10% to the existing amounts?
 
R

Ron Coderre

Try this:
In a blank cell, enter 1.1
Edit>Copy
Select the cells you want increased by 10%
Edit>Paste Special>
Check: Multiply
Check: Values
Click the [OK] button

Does that help?

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

XL2002, WinXP-Pro
 
Top