how to correct the decimal number to the nearest even number
 

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

how to correct the decimal number to the nearest even 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 to correct the decimal number to the nearest even 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

how to correct the decimal number to the nearest even 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