OK, I have thunk up a new chart based on the retail margin method and
here it is:

$1-50 - 25% (Cost/.75)
$51-75 - 20% (Cost/.8)
$76-100 - 15% (Cost/.85)
$101+ - 10% (Cost/.9)

Now I just need to figure out the formula/macro to make it work.


--
ElNino
------------------------------------------------------------------------
ElNino's Profile: http://www.excelforum.com/member.php...o&userid=25725
View this thread: http://www.excelforum.com/showthread...hreadid=391062