hi,

=--(LEFT(A1,LEN(A1)-1)&9)

--
isabelle



Le 2012-05-04 15:15, stumjumper a écrit :
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