View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
autiemomtoo autiemomtoo is offline
external usenet poster
 
Posts: 3
Default adding percentages to cells

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?