Adding % to existing cell values
Enter 1.04 in an empty cell
Copy that cell: EditCopy
Select the cells you want to increase
Then, EditPaste SpecialMultiplyOK
--
Biff
Microsoft Excel MVP
"John" wrote in message
...
I should know this....but, how do I add 4% to a range of cells?
(I'm trying to update a price sheet by increasing the % on existing
prices)
Thanks!
--
John
|