From ZCubes Wiki
Revision as of 04:37, 3 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''ISBOOLEAN(Thing)'''</div><br/> *<math>Thing</math> is any value ==Description== *<math>ISBOOLEAN</math> function checks if the argument returns...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

  • is any value


  • function checks if the argument returns the value 'true' or 'false'. For argument value other than 'true' or 'false' it returns the result as 'false'.
  • This function is one of the group in .
  • The is also known as data information functions, data inspection functions or data-testing functions.
  • This function is gives the result as TRUE when the given value is logical like either true or false otherwise this function will return the result as FALSE.
  • Argument can be blank, or it can contain data such as text, numbers, error values, or logical values.


  • The syntax is to calculate ISBOOLEAN in ZOS is .
    • is the any value.
  • For e.g.,ISBOOLEAN(TRUE)


  1. =ISBOOLEAN(TRUE)= true
  2. =ISBOOLEAN(FALSE)= true
  3. =ISBOOLEAN(1)=false
  4. =ISBOOLEAN(0)=false
  5. =ISBOOLEAN(2)=false
  6. =ISBOOLEAN(8>5)= true
  7. =ISBOOLEAN(SUM(5,6)>PRODUCT(2,5))= true

Related Videos


See Also


Is functions