Difference between revisions of "Manuals/calci/ISEVEN"
Jump to navigation
Jump to search
Line 23: | Line 23: | ||
==See Also== | ==See Also== | ||
− | *[[Manuals/calci/ | + | *[[Manuals/calci/ISODD | ISODD ]] |
− | *[[Manuals/calci/ | + | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] |
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Correlation] | [http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Correlation] |
Revision as of 01:27, 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
- ISEVEN(12)=TRUE
- ISEVEN(51)=FALSE
- ISEVEN(0)=TRUE
- ISEVEN(-2)=TRUE
- ISEVEN(1+5)=TRUE
- ISEVEN(8-3)=FALSE
- ISEVEN(10*20)=TRUE
- ISEVEN(1058/8)=TRUE
- ISEVEN("100")=NAN