Converting cost price to retail in vast array

D

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
 
P

pdberger

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top