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...
You don't say what the result should be for an entry such as 5.87, which is equidistant from 5.85 and 5.89. This will favour the former:
=LET(
ζ, A1,
ξ, MROUND(ζ, 0.05),
ξ - IF(MOD(ξ * 100, 10), 0, 0.01)
)
Regards