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

On Mon, 23 Jan 2006 07:38:04 -0800, "Gian"
wrote:

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

=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

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

Gian:

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

=INT(A1*2+1)/2

--
HTHs Martin


"Gian" wrote:

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