Difference between revisions of "Manuals/calci/ISLOGICAL"
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 | + | *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 04: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
- ISLOGICAL(true)=TRUE
- ISLOGICAL(false)=TRUE
- ISLOGICAL(1)=TRUE
- ISLOGICAL(0)=TRUE
- ISLOGICAL(2)=FALSE
- ISLOGICAL(-1)=FALSE