Rounding to nearest 0.5 in Excel 2007

[Richard in Stockholm]

Hi there! Is there something that you can do within formatting to round
figures to the nearest 0.5? I need to work with a lot of figures that need
to be rounded to the nearest 0.5 either up or down and I cant seem to find
anything except functions that round to the nearest 0.1 or 0.01 etc.

Can anyone help??

 

[Peo Sjoblom]

=ROUND(A1/0.5,0)*0.5

in Swedish


=AVRUNDA(A1/0,5;0)*0,5


--


Regards,


Peo Sjoblom

 

[Gary''s Student]

=MROUND(A1,0.5)

 

[Bernd P]

Hello,

=ROUND(A1*2,0)/2

or

=ROUND(A1/5,1)*5

Regards,
Bernd

 

[Richard in Stockholm]

Tack, precis det jag behövde!!!

"Peo Sjoblom" skrev: