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