software

how do i round to the nearest 0.5

=ROUND(Value/0.5,0)*0.5--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;bigredquot; gt; wrote in message
...
gt; how do i round to the nearest 0.5
Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article gt;,
bigred gt; wrote:

gt; 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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=532806works great
thanks

quot;Domenicquot; wrote:

gt; Try...
gt;
gt; =ROUND(A1/0.5,0)*0.5
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; bigred gt; wrote:
gt;
gt; gt; how do i round to the nearest 0.5
gt;