Can I increase an entire column by a percentage?
In a blank cell insert 1.05 copy the cell, and then highlight the whole list
(not the whole column, just the cells you want to multiply). Select
Edit-Paste Special and then select multiply under Operation. Hit okay. All
selected values should be increased by 5%.
"KandyKane" wrote:
I need to increase an entire column by 5% (price list increase). Can I do
this with one individual forula? Do I have to do every row individually?
|