round to ,5
 

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

round to ,5
 

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

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



--
Regards
Frank Kabel
Frankfurt, Germany

"Jean-Paul De Winter" schrieb im Newsbeitrag
...
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

round to ,5
 

one way

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

"Jean-Paul De Winter" wrote in message
...
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

round to ,5
 

Jean-Paul,

Try this

=ROUND(A1/5,1)*5

Neil.

"Jean-Paul De Winter" wrote in message
...
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

round to ,5
 

JP

use: =MROUND(A1,0.5)

Regards

Trevor


"Jean-Paul De Winter" wrote in message
...
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