correct to the nearest half
 

correct to the nearest half
 

It wouild have been better if you had explained more fully what it is that
you want to do in the body of the post, but taking a guess try:

=ROUND(A1*2,0)/2
--
HTH

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


with @tiscali.co.uk


"soorya" wrote in message
...

correct to the nearest half
 

Hi soorya,

You can also use =MROUND(A1,0.5)

You will need to have the Analysis Tool Pack installed in order
to use MROUND. See the help file for details on how to do
this.

HTH
Martin