Hi,

Do it in several steps and for the first markup of 50% try this. Put 1.5 in
a cell and copy it. Select rows 1 to 208 and right click them, click 'paste
Special' select 'Multiply' and then OK.

Repeat for other markups
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?