What will be the result of the following MS-Excel formula? =ODD(20)+EVEN(39)

What will be the result of the following MS-Excel formula? =ODD(20)+EVEN(39) Correct Answer 61

The correct answer is 61.

Key Points

  • 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.

Additional Information

  • 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. 

Related Questions

The following is Boltzman's entropy formula. What does W represent in the given formula? S = k log W