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