From ZCubes Wiki
Jump to navigation Jump to search
ISODD (Number)

  • is any number to test.
    • ISODD(), returns TRUE if the number is odd.


  • 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.


  1. =ISODD(5) = TRUE
  2. =ISODD(0) = FALSE
  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
  9. =max=12;1..max.filter(x=>ISODD(x)) = 1 3 5 7 9 11
  10. max=12;SUM(1..max.filter(x=>ISODD(x))) = 36

Related Videos


See Also


Is Function