Cell Markups

[Guest]

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?

 

[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"

 

[Guest]

Thanks - such a simple solution, just the way I like it.

 

[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