Difference between revisions of "Manuals/calci/ISEVEN"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''ISEVEN (Number)'''</div><br/> |
| + | *<math>Number</math> is any number to test. | ||
| + | **ISEVEN(), returns TRUE if the number is even. | ||
| − | + | ==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 can be 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 | ||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|Nd0JfLStYG8|280|center|ISEVEN}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/ISODD | ISODD ]] | ||
| + | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Is_functions Is Function] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 07:19, 11 February 2020
ISEVEN (Number)
- is any number to test.
- ISEVEN(), returns TRUE if the number is even.
is any number 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 can be 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
Related Videos
See Also
References