Cell Markups
 

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?

Cell Markups
 

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"
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Wackman" wrote in message
...
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?

Cell Markups
 

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

"Bernard Liengme" wrote:

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"
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Wackman" wrote in message
...
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?

Cell Markups
 

Enter 1.15 in an unused cell.

Copy that cell.

Select your range of prices and EditPaste SpecialMultiplyOKEsc

Clear the cell with 1.15


Gord Dibben MS Excel MVP

On Thu, 15 Nov 2007 07:35:01 -0800, Wackman
wrote:

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?