Quote:
Originally Posted by stumjumper
I use this formula to come up with the prices for my retail products.
A1 cost of product
B1 percent markup, 100%
C1 =MROUND(A1*(1+(B1)),5) this would give me my price
I have been doubling my cost then rounding that to the nearest
multiple of 5 to come up with my price.
What I would like to do is instead of rounding to nearest multiple of 5
is round the number up to the next number that ends with a 9.
Example 176 round up to 179
173 round up to 179
161 round up to 169
Is there a way to do this in excel?
Any help would be greatly appreciated!
Thanks
|
<<<<< HELP from BRAZIL
Dear stumjumper, Good Afternoon.
Try this one:
C1 -- =IF((A1*(1+(B1)))(MROUND(A1*(1+(B1)),10)),(MROUND (A1*(1+(B1)),10))+9,(A1*(1+(B1))))
Tell me if it worked for you.
Have a nice day.
__________________
I hope it can help you.
Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
|