Try:

=ROUND(A1*2,0)/2
or
=INT(A1*2+0.5)/2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"VPHR" wrote in message
...
How can I round 3.4 to 3.5 instead of 3.0 or 4.0?