What is the formula to correct the decimal number to the nearest even (not odd number)number
S santosh kutre Nov 3, 2008 #1 What is the formula to correct the decimal number to the nearest even (not odd number)number
S shg Nov 3, 2008 #4 =INT(A1) + ISODD(A1) =MROUND(A1, 2) Click to expand... If A1<0, the first formula returns an odd number and the second return #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
=INT(A1) + ISODD(A1) =MROUND(A1, 2) Click to expand... If A1<0, the first formula returns an odd number and the second return #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
