round to ,5

[Jean-Paul De Winter]

Hi,
When a value is 60.12 I want it to be rounded to 60.00
a value 60.45 to 60.50
a value 60.57 to 60.50
a value 60.85 to 61.00
does somebody know s how?
Thanks
JP

 

[Frank Kabel]

Hi
=Round(A1*2,0)/0.5

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

 

[Bill Kuunders]

one way

=(ROUND(A1*2,0))/2
Regards
Bill K

 

[Neil]

Jean-Paul,

Try this

=ROUND(A1/5,1)*5

Neil.

 

[Trevor Shuttleworth]

JP

use: =MROUND(A1,0.5)

Regards

Trevor