Round numbers to get to the nearest 0.09
 

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

Round numbers to get to the nearest 0.09
 

I think this will do what you want...

=ROUND(A1,1)-0.01

--
Rick (MVP - Excel)


"KB" wrote in message
...
How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)

Round numbers to get to the nearest 0.09
 

With a bit of playing around I came up with
=ROUND(A1,1) - 0.01
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"KB" wrote in message
...
How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)

Round numbers to get to the nearest 0.09
 

=ROUND(A1,1)-0.01


"KB" wrote:

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

Round numbers to get to the nearest 0.09
 

On Mon, 23 Nov 2009 12:44:02 -0800, KB wrote:

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

Round numbers to get to the nearest 0.09
 

On Mon, 23 Nov 2009 15:57:58 -0500, "Rick Rothstein"
wrote:

I think this will do what you want...

=ROUND(A1,1)-0.01

--
Rick (MVP - Excel)

Am I missing something?

A1: 3.541


I would have thought:

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

Round numbers to get to the nearest 0.09
 

I think this will do what you want...

=ROUND(A1,1)-0.01

--
Rick (MVP - Excel)

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.

--
Rick (MVP - Excel)

Round numbers to get to the nearest 0.09
 

On Mon, 23 Nov 2009 16:52:47 -0500, "Rick Rothstein"
wrote:

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.

--
Rick (MVP - Excel)

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