Rounding a number to the closest .2

**ksvarner** · 06-26-2009, 09:32 AM

Hi,

Does anyone know a way to round a number in a cell to the closest .2? For example, 14.51 would round to 14.6 and 14.49 would round to 14.4. I understand the ROUND command, but I think this is going to involve some IF statements. Please let me know any thoughts. Thanks!

**DonkeyOte** · 06-26-2009, 09:41 AM

Yes you can use ROUND

=ROUND(A1/0.2,0)*0.2

Or you can activate that Analysis ToolPak (see: Tools - Add-Ins) and make use of the MROUND function

=MROUND(A1,0.2)