Round to .05 or .09
Bruce wrote...
How can I round prices to the nearest 0.05 or 0.09?
Eg 1
5.01 to 4.99
Eg 2
4.44 to 4.45
Meaning the last digit would always be either a 9 or a 5?
to 0.09: =ROUND(x,1)-0.01
to 0.05: =ROUND($A1,1)-0.05
Note: using the first, 5.04 rounds down to 4.99; using the second, 4.
|