hi there,

I would like to know what's the easy method for working out profi
margin especially for 17,000 products with variation price

all the variation price is at the column C:

but it would be nice to add variation profit margin for each price eg.

lower price (1.00 to 1000) = higher profit margin
higher price = (1001 to 60,000) lower profit margin

thank for ur hel

--
Message posted from http://www.ExcelForum.com