=FLOOR(A1,0.5)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter lansberg" <Peter wrote in message
...
I would like to round numbers down not only to integers but also to 0.5
values
eg 6.7 would be 6.5 and 6.4 should be 6.0.
appreciate your help
Peter Lansberg