K
KB
How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)
(4.17=4.19 or 4.12=4.09)
R
Rick Rothstein
I think this will do what you want...
=ROUND(A1,1)-0.01
=ROUND(A1,1)-0.01
B
Bernard Liengme
With a bit of playing around I came up with
=ROUND(A1,1) - 0.01
best wishes
=ROUND(A1,1) - 0.01
best wishes
J
JBoulton
=ROUND(A1,1)-0.01
R
Ron Rosenfeld
=ROUND(A1+0.01,1)-0.01
--ron
R
Ron Rosenfeld
Am I missing something?
A1: 3.541
I would have thought:
=ROUND(A1+0.01,1)-0.01
--ron
R
Rick Rothstein
I think this will do what you want...
No, you are not missing anything... adding the 0.01 to the value inside the
ROUND function as you show in your post is the correct way to do this.
No, you are not missing anything... adding the 0.01 to the value inside the
ROUND function as you show in your post is the correct way to do this.
R
Ron Rosenfeld
Sometimes, in those hours between the start of cocktail time and dinner, I've
been known to miss things
--ron