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)

if function with rounding	4	Apr 30, 2007
ROUNDUP to nearest 1/16 (in decimals)	0	May 12, 2009
Round numbers to get to the nearest 0.09	7	Nov 23, 2009
Convert Decimal fractions to binary and vice versa	1	Jul 11, 2014
rounding up to the nearest 1000	1	Feb 23, 2010
How to subtract a number from a Mergefield?	0	Feb 12, 2025
Rounding Cell Values	3	Jan 5, 2009
time calculation	7	Feb 2, 2009

Ask a Question