Difference between revisions of "Manuals/calci/ISLOGICAL"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISLOGICAL'''(Value) where, '''Value''' - represents the value in cell. </div> ---- <div id="1SpaceCo...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''ISLOGICAL(n)'''</div><br/> |
| + | *<math>n</math> is the logical value | ||
| − | + | ==Description== | |
| + | *This function is one of the group in <math>ISFUNCTIONS</math>. | ||
| + | *The <math>IS FUNCTION</math> is also known as data information functions, data inspection functions or data-testing functions. | ||
| + | *<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. | ||
| + | *Also true has value of 1and 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. | ||
| − | + | ==Examples== | |
| + | #ISLOGICAL(true)=TRUE | ||
| + | #ISLOGICAL(false)=TRUE | ||
| + | #ISLOGICAL(1)=TRUE | ||
| + | #ISLOGICAL(0)=TRUE | ||
| + | #ISLOGICAL(2)=FALSE | ||
| + | #ISLOGICAL(-1)=FALSE | ||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
| + | *[[Manuals/calci/ISODD | ISODD ]] | ||
| + | *[[Manuals/calci/ISEVEN | ISEVEN ]] | ||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 05:01, 20 December 2013
ISLOGICAL(n)
- is the logical value
is the logical valueDescription
- 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 1and 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.
.
is also known as data information functions, data inspection functions or data-testing functions.
is used to find the given Examples
- ISLOGICAL(true)=TRUE
- ISLOGICAL(false)=TRUE
- ISLOGICAL(1)=TRUE
- ISLOGICAL(0)=TRUE
- ISLOGICAL(2)=FALSE
- ISLOGICAL(-1)=FALSE