Converting cost price to retail in vast array

[dstooch]

Hi Folks,
My question is: I have 25 model numbers and each of them has 4-
differnet pieces. I have them setup in Excel with the cost price o
each and would like to generate retail prices based on a certai
multiplier..such as 2.5 times the cost. To further add to the mix, m
pricing at retail has to end in 8. Therefore, if the extended price i
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 appreciat
any help.

Thanks in advance.
Dstooc

 

[Guest]

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.