Hi Folks,
My question is: I have 25 model numbers and each of them has 4-5
differnet pieces. I have them setup in Excel with the cost price of
each and would like to generate retail prices based on a certain
multiplier..such as 2.5 times the cost. To further add to the mix, my
pricing at retail has to end in 8. Therefore, if the extended price is
below 5 it drops to the lower 8 or above 5, it rises to the higher 8.

This has had me stumped for a few weeks and I would greatly appreciate
any help.

Thanks in advance.
Dstooch


--
dstooch
------------------------------------------------------------------------
dstooch's Profile: http://www.excelforum.com/member.php...o&userid=32967
View this thread: http://www.excelforum.com/showthread...hreadid=527926