Question

What will be the result of the following MS-Excel formula?
=ODD(20)+EVEN(39)
1. 57
2. 50
3. 61
4. 59

Answer 1

Correct Answer - Option 3 : 61

The correct answer is 61.

• The ODD function rounds a positive number up to the nearest odd integer. 
• The EVEN function rounds a positive number up to the nearest even integer.
• ODD(20) equals 21.
• EVEN(39) equals 40.
• Hence, the Sum is 61.

• The ISEVEN function returns TRUE if a number is even and FALSE if a number is odd.
• The ISODD function returns TRUE if a number is odd and FALSE if a number is even.