Round to the nearest even decimal point

[lewdow]

Hi,

I am looking to round a value to the nearest even decimal point.....the obvious combination of ROUND() and EVEN() makes it the nearest even integer, where as I need it to 2 decimal places e.g.

291.97 --> 291.98

Any simple way to do this?

Thanks

Lewis

 

[barry houdini]

If your value is in A1 try

=ROUND(A1/0.02,0)*0.02

or you can use Analysis ToolPak function MROUND (built in in Excel 2007)

=MROUND(A1,0.02)

 

[mikerickson]

How about
=FLOOR(A1+0.01, 0.02)

 

[lewdow]

Spot on. Many thanks.