Round numbers to get to the nearest 0.09

[KB]

How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)

 

[Rick Rothstein]

I think this will do what you want...

=ROUND(A1,1)-0.01

 

[Bernard Liengme]

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

 

[JBoulton]

=ROUND(A1,1)-0.01

 

[Ron Rosenfeld]

How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)

=ROUND(A1+0.01,1)-0.01
--ron

 

[Ron Rosenfeld]

I think this will do what you want...

=ROUND(A1,1)-0.01

Am I missing something?

A1: 3.541


I would have thought:

=ROUND(A1+0.01,1)-0.01
--ron

 

[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

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.

 

[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.

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