Round function

[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

 

[Ron Rosenfeld]

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

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

 

[Bob Phillips]

=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)

 

[Guest]

Thanks guys.

=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)

 

[Guest]

Gian:

Am I missing something or can't you just use the following formula:

=INT(A1*2+1)/2