writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − '''ISLOGICAL'''(Value)+ + + + + + + − where,+ + + + + + + − '''Value''' - represents the value in cell.+ + + + − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left">If cell having true or false, ISLOGICAL returns 1.</div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − ISLOGICAL − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column1, Row2) − − <nowiki>=ISLOGICAL(R1C1)</nowiki> − − ISLOGICAL returns 1. − − Cosider an another example − − <nowiki>=ISLOGICAL("GFSJH")</nowiki> − − It returns 0. − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | class=" " | Column1 − | class=" " | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | true − | class="sshl_f " | 0 − | 0 − | 0 − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 1 − | class="sshl_f" | 0 − | 0 − | 0 − |- class="odd" − | Row3 − | 0 − | class=" SelectTD ChangeBGColor SelectTD" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> − | 0 − | 0 − |- class="even" − | Row4 − | 0 − | 0 − | 0 − | 0 − |- class="odd" − | class=" " | Row5 − | 0 − | 0 − | 0 − | 0 − |- class="even" − | Row6 − | 0 − | 0 − | 0 − | 0 − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
Manuals/calci/ISLOGICAL (view source)
Revision as of 10:01, 20 December 2013
, 10:01, 20 December 2013no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<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==