rounding numbers
 

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

rounding numbers
 

=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

rounding numbers
 

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

rounding numbers
 

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