Forum Discussion
How to Round to nearest 0.04 or 0.09
Hello, I am trying to round product prices to the nearest 0.04 or 0.09. For example if a price is 5.88 I need it rounded to 5.89, and if a product is 5.56 I need it to round to 5.54. I ahve tried...
I used your mround suggestion then subtracted .01 , thank you!
=mround(A1, 0.05)-.01
but now I have another client interested in having the cents end in .07 and .04 instead of .09/.04... hmm...
=mround(A1, 0.05)-.01
but now I have another client interested in having the cents end in .07 and .04 instead of .09/.04... hmm...
How about
=A1+CHOOSE(MOD(100*A1, 10)+1, -0.03, 0.03, 0.02, 0.01, 0, -0.01, 0.01, 0, -0.01, -0.02)