how do i round to the nearest 0.5

=ROUND(Value/0.5,0)*0.5


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"bigred" wrote in message
...
how do i round to the nearest 0.5

Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article ,
bigred wrote:

how do i round to the nearest 0.5

=ROUND(A1*2,0)/2

or using MROUND from analysis toolpak add-in

=MROUND(A1,0.5)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=532806

works great
thanks

"Domenic" wrote:

Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article ,
bigred wrote:

how do i round to the nearest 0.5