rounding to nearest 0.5 in excel

how do i round to the nearest 0.5

=ROUND(Value/0.5,0)*0.5


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"bigred" <bigred@discussions.microsoft.com> wrote in message
news:F9C6753E-38B1-48D4-B4CD-D1A1569063A1@microsoft.com...
> how do i round to the nearest 0.5

Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article <F9C6753E-38B1-48D4-B4CD-D1A1569063A1@microsoft.com>,
bigred <bigred@discussions.microsoft.com> 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)

works great
thanks

"Domenic" wrote:

> Try...
>
> =ROUND(A1/0.5,0)*0.5
>
> Hope this helps!
>
> In article <F9C6753E-38B1-48D4-B4CD-D1A1569063A1@microsoft.com>,
> bigred <bigred@discussions.microsoft.com> wrote:
>
> > how do i round to the nearest 0.5
>