Manuals/calci/ISEVEN

Revision as of 01:26, 12 December 2013 by Jayaram (talk | contribs)
ISEVEN(n)


  • is the value to test.

Description

  • This function is one of the group in ISFUNCTIONS.
  • The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
  • ISEVEN function canbe used to check the given value is even or not.
  • This function gives the result as only TRUE or FALSE.
  • The result is TRUE when the n value is even otherwise the result is FALSE.
  • The argument can be blank, or it can contain data such as text, numbers, error values, logical values or any equations.
  • This function will not convert any numbers from text.
  • For e.g. "20" is normally converted as a number 20.
  • But in ISEVEN("20") will return NAN, because "20" will not convert in to number.

Examples

  1. ISEVEN(12)=TRUE
  2. ISEVEN(51)=FALSE
  3. ISEVEN(0)=TRUE
  4. ISEVEN(-2)=TRUE
  5. ISEVEN(1+5)=TRUE
  6. ISEVEN(8-3)=FALSE
  7. ISEVEN(10*20)=TRUE
  8. ISEVEN(1058/8)=TRUE
  9. ISEVEN("100")=NAN

See Also

References

Correlation