What is the formula to correct the decimal number to the nearest even (not
odd number)number

=mround(A2,2).
Look at Excel help for the mround function.
--
David Biddulph

"santosh kutre" <santosh wrote in message
...
What is the formula to correct the decimal number to the nearest even (not
odd number)number

How about

Even: =INT(A1)+ISODD(A1)

Odd: =INT(A1)+ISEVEN(A1)

--
__________________________________
HTH

Bob

"santosh kutre" <santosh wrote in message
...
What is the formula to correct the decimal number to the nearest even (not
odd number)number

=INT(A1) + ISODD(A1)
=MROUND(A1, 2)
If A1<0, the first formula returns an odd number and the second returns
#NUM!

If your data includes negative numbers, you could use either

=INT(A1) + ISODD(INT(A1))

=MROUND(A1, 2*SIGN(A1))

MROUND requires the Analysis ToolPak add-in.


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24393