Pleasure.

Regards

Bob

"Peter lansberg" wrote in message
...
Dear Bob
worked great. Thanks for your help
Peter


"Bob Phillips" wrote:

=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