Round numbers to get to the nearest 0.09

B

Bernard Liengme

With a bit of playing around I came up with
=ROUND(A1,1) - 0.01
best wishes
 
R

Rick Rothstein

I think this will do what you want...
Am I missing something?

A1: 3.541

I would have thought:

=ROUND(A1+0.01,1)-0.01
Click to expand...

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

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.
Click to expand...

Sometimes, in those hours between the start of cocktail time and dinner, I've
been known to miss things :)
--ron
 
Top