how to correct the decimal number to the nearest even number

santosh kutre · Nov 3, 2008

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

Bob Phillips · Nov 3, 2008

How about

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

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