Difference between revisions of "Manuals/calci/ISLOGICAL"
Jump to navigation
Jump to search
Line 11: | Line 11: | ||
==Examples== | ==Examples== | ||
− | #ISLOGICAL(true)=TRUE | + | #=ISLOGICAL(true)=TRUE |
− | #ISLOGICAL(false)=TRUE | + | #=ISLOGICAL(false)=TRUE |
− | #ISLOGICAL(1)=TRUE | + | #=ISLOGICAL(1)=TRUE |
− | #ISLOGICAL(0)=TRUE | + | #=ISLOGICAL(0)=TRUE |
− | #ISLOGICAL(2)=FALSE | + | #=ISLOGICAL(2)=FALSE |
− | #ISLOGICAL(-1)=FALSE | + | #=ISLOGICAL(-1)=FALSE |
==See Also== | ==See Also== |
Revision as of 07:03, 26 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