Difference between revisions of "Manuals/calci/ISEVEN"

From ZCubes Wiki
Jump to navigation Jump to search
Line 27: Line 27:
  
 
==References==
 
==References==
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Correlation]
+
[http://en.wikipedia.org/wiki/Is_functions Is Function]

Revision as of 04:34, 12 December 2013

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

Is Function