Difference between revisions of "Manuals/calci/ISODD"

From ZCubes Wiki
Jump to navigation Jump to search
Line 26: Line 26:
  
 
==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 03:38, 12 December 2013

ISODD(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.
  • ISODD function can be used to check the given value is odd or not.
  • This function gives the result as only TRUE or FALSE.
  • The result is TRUE when the value is odd 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 the text.
  • For e.g. "11" is normally converted as a number 11.
  • But in ISODD("11") will return NAN, because "11" will not convert in to number.

Examples

  1. ISODD(5)=TRUE
  2. ISODD(0)=TRUE
  3. ISODD(100)=FALSE
  4. ISODD(5*3)=TRUE
  5. ISODD(500/10.5)=TRUE
  6. ISODD(5624.76-2654.42)=FALSE
  7. ISODD(265+452)=TRUE
  8. ISODD(-465)=TRUE

See Also

References

Is Function