Cell Markups

W

Wackman

I would like to know if it is possible to apply a 'blanket' markup on
existing cell definitions across an entire spreadsheet.
I already have the figures, how do I add 15% to them all? Is there a simple
way to do this or do I have to apply a calculation to each cell?
 
B

Bernard Liengme

This must be a homework problem
See my answer to same question today on this newsgroup
"Question on how to raise a price 15% in a coloum"
 
G

Gord Dibben

Enter 1.15 in an unused cell.

Copy that cell.

Select your range of prices and Edit>Paste Special>Multiply>OK>Esc

Clear the cell with 1.15


Gord Dibben MS Excel MVP
 
Top