Round function
Thanks guys.
"Bob Phillips" wrote:
=CEILING(A1,0.5)
But 1.5 stays as 1.5, it has already hit it's ceiling.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Gian" wrote in message
...
Hi,
How can I round a number with increment of 0.5 ? For e.g. 0.1 will be
equal
to 0.5, 1.1 will be equal to 1.5, 1.5 will be equal to 2.0 etc.
Thanks.
Gian
|