software

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: www.excelforum.com/member.php...oamp;userid=32967
View this thread: www.excelforum.com/showthread...hreadid=527926Dstooch --

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.

quot;dstoochquot; wrote:

gt;
gt; Hi Folks,
gt; My question is: I have 25 model numbers and each of them has 4-5
gt; differnet pieces. I have them setup in Excel with the cost price of
gt; each and would like to generate retail prices based on a certain
gt; multiplier..such as 2.5 times the cost. To further add to the mix, my
gt; pricing at retail has to end in 8. Therefore, if the extended price is
gt; below 5 it drops to the lower 8 or above 5, it rises to the higher 8.
gt;
gt; This has had me stumped for a few weeks and I would greatly appreciate
gt; any help.
gt;
gt; Thanks in advance.
gt; Dstooch
gt;
gt;
gt; --
gt; dstooch
gt; ------------------------------------------------------------------------
gt; dstooch's Profile: www.excelforum.com/member.php...oamp;userid=32967
gt; View this thread: www.excelforum.com/showthread...hreadid=527926
gt;
gt;