Round to the nearest even decimal point

lewdow

New Member
Joined
Oct 8, 2008
Messages
25
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

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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)
 

Forum statistics

Threads
1,085,331
Messages
5,383,009
Members
401,811
Latest member
emelyan1379

Some videos you may like

This Week's Hot Topics

Top