Converting cost price to retail in vast array
 

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

Converting cost price to retail in vast array
 

Dstooch --

It sounds like you have two issues -- computing the retail price, and then
ending up with $XX8. I'm not sure why you can't (using your example)
multiply the cost by 2.5, so I can't offer anything for your first issue.
Regarding the second, I'd round to the nearest 10 dollars, then subtract 2.
So, if you wanted to end up at the $8 level, I'd approach it like this:
A B C
1 $10 $25 =mround(b1,10)-2

HTH.

"dstooch" wrote:


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