Round function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

Normal rounding up to 0.5 would leave 1.5=1.5.

So to do what you describe, you could add a very small amount to your values.
This will also cause 2.0-->2.5

=CEILING(A8+(10^-10),0.5)


--ron
 
=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)
 
Thanks guys.

Bob Phillips said:
=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)
Click to expand...
 
Back
Top