Difference between revisions of "Manuals/calci/ISLOGICAL"

From ZCubes Wiki
Jump to navigation Jump to search
Line 7: Line 7:
 
*<math>ISLOGICAL</math> is used to find the given <math>n</math>  is logical (true or false).  
 
*<math>ISLOGICAL</math> is used to find the given <math>n</math>  is logical (true or false).  
 
*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.
 
*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.
*Also true has value of 1and false has taken value of 0.  
+
*Also true has value of '1' and false has taken value of '0'.  
 
*For the <math>ISFUNCTION</math> the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.
 
*For the <math>ISFUNCTION</math> the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.
  

Revision as of 05:02, 20 December 2013

ISLOGICAL(n)


  • is the logical value

Description

  • This function is one of the group in .
  • The is also known as data information functions, data inspection functions or data-testing functions.
  • is used to find the given is logical (true or false).
  • 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.
  • Also true has value of '1' and false has taken value of '0'.
  • For the the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

Examples

  1. ISLOGICAL(true)=TRUE
  2. ISLOGICAL(false)=TRUE
  3. ISLOGICAL(1)=TRUE
  4. ISLOGICAL(0)=TRUE
  5. ISLOGICAL(2)=FALSE
  6. ISLOGICAL(-1)=FALSE

See Also

References