Round function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gian - 23 Jan 2006 15:38 GMT

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

Reply to this Message

Ron Rosenfeld - 23 Jan 2006 15:48 GMT

>Hi,
>
[quoted text clipped - 4 lines]
>
>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

Reply to this Message

Bob Phillips - 23 Jan 2006 15:52 GMT

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

> Hi,
>
[quoted text clipped - 4 lines]
>
> Gian

Reply to this Message

Gian - 23 Jan 2006 16:11 GMT

Thanks guys.

> =CEILING(A1,0.5)
>
[quoted text clipped - 17 lines]
> >
> > Gian

Reply to this Message

Martin Fishlock - 23 Jan 2006 16:17 GMT

Gian:

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

=INT(A1*2+1)/2

Signature

HTHs Martin

> Hi,
>
[quoted text clipped - 4 lines]
>
> Gian

Reply to this Message