rounding to nearest 0.5 in excel

Guest · Apr 13, 2006

how do i round to the nearest 0.5

Peo Sjoblom · Apr 13, 2006

=ROUND(Value/0.5,0)*0.5

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

Domenic · Apr 13, 2006

Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

daddylonglegs · Apr 13, 2006

=ROUND(A1*2,0)/2

or using MROUND from analysis toolpak add-in

=MROUND(A1,0.5)

Guest · Apr 14, 2006

works great
thanks

Domenic said:
Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!