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
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