Difference between revisions of "Manuals/calci/ISODD"
Jump to navigation
Jump to search
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''ISODD( | + | <div style="font-size:30px">'''ISODD (Number)'''</div><br/> |
− | *<math> | + | *<math>Number</math> is any number to test. |
+ | **ISODD(), returns TRUE if the number is odd. | ||
+ | |||
==Description== | ==Description== | ||
*This function is one of the group in ISFUNCTIONS. | *This function is one of the group in ISFUNCTIONS. | ||
Line 6: | Line 8: | ||
*ISODD function can be used to check the given value is odd or not. | *ISODD function can be used to check the given value is odd or not. | ||
*This function gives the result as only TRUE or FALSE. | *This function gives the result as only TRUE or FALSE. | ||
− | *The result is TRUE when the <math> | + | *The result is TRUE when the <math>Number</math> 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. | *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. | *This function will not convert any numbers from the text. | ||
Line 21: | Line 23: | ||
#=ISODD(265+452) = TRUE | #=ISODD(265+452) = TRUE | ||
#=ISODD(-465) = TRUE | #=ISODD(-465) = TRUE | ||
+ | #=max=12;1..max.filter(x=>ISODD(x)) = 1 3 5 7 9 11 | ||
+ | #max=12;SUM(1..max.filter(x=>ISODD(x))) = 36 | ||
==Related Videos== | ==Related Videos== |
Latest revision as of 01:03, 30 June 2021
ISODD (Number)
- is any number to test.
- ISODD(), returns TRUE if the number is odd.
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 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
- =ISODD(5) = TRUE
- =ISODD(0) = FALSE
- =ISODD(100) = FALSE
- =ISODD(5*3) = TRUE
- =ISODD(500/10.5) = TRUE
- =ISODD(5624.76-2654.42) = FALSE
- =ISODD(265+452) = TRUE
- =ISODD(-465) = TRUE
- =max=12;1..max.filter(x=>ISODD(x)) = 1 3 5 7 9 11
- max=12;SUM(1..max.filter(x=>ISODD(x))) = 36
Related Videos
See Also
References