writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − '''ISPRIME'''(SomeNumber)+ + + + + + + + + − where+ + + + + + + − '''SomeNumber '''is any real number.+ + + + − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − − ISPRIME function determines whether the given number is a prime number or not. − − ISPRIME function returns 1 if the given number is prime and returns 0 if the given number is not prime.<br /> − − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − ISPRIME returns NaN if SomeNumber is not real − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − ISPRIME − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column2Row1) − − <nowiki>=ISPRIME(Column1Row1)</nowiki> − − Returns 1 for ISPRIME(3) − − Consider another example in (Column2Row2) − − <nowiki>=ISPRIME(Column1Row2)</nowiki> − − Returns 0 for ISPRIME(4) − − </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" − |+ Default Calci − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f" | 3 − | class="sshl_f" | 1 − | class=" sshl_f sshl_f" | − | class=" sshl_f sshl_f" | − |- class="even" − | class=" " | Row2 − | class=" 1 " | 4 − | class="sshl_f" | 0 − | class=" sshl_f" | − | class="sshl_f sshl_f" | − |- class="odd" − | Row3 − | class="sshl_f " | − | class=" sshl_f sshl_f SelectTD1 ChangeBGColor SelectTD1" | − <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> − | class="sshl_f " | − | class="sshl_f" | − |- class="even" − | Row4 − | class=" " | − | class=" sshl_f" | − | class="sshl_f" | − | − |- class="odd" − | class=" " | Row5 − | − | class=" sshl_f" | − | class="sshl_f" | − | − |- class="even" − | Row6 − | − | − | class="sshl_f" | − | − |} − − {| − | <span align="left">[[Image:calci1.gif]]</span> − | − | − [[Image:bold.gif]] − | − [[Image:italic.gif]] − | − [[Image:normal.gif]] − | − [[Image:underline.gif]] − | − [[Image:border.gif]] − | − [[Image:numbers.gif]] − | − [[Image:sort.gif]] − | − [[Image:formatcells.gif]] − | − [[Image:graphs.gif]] − | $ − |} − − </div> − ----
Manuals/calci/ISPRIME (view source)
Revision as of 07:16, 23 December 2013
, 07:16, 23 December 2013no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''ISPRIME(n)'''</div><br/>
*<math>n</math> is the number
==Description==
*This function is one of the group in ISFUNCTIONS.
*The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
*ISPRIME function is used to test the given number is prime or not.
*This function gives the result as TRUE when the given value is prime otherwise this function gives th result as FALSE.
*A prime number is a natural number, it can be divided, without a remainder, only by itself and by 1.
*For e.g. The number 11 is a prime, because 11 is divided by 1 and 11 without any remainder.
*But 6 is not prime, because 6 can be divided by 1,2,3 and 6.
*Also the number 0 and 1 are neither prime nor composite.
==Examples==
#ISPRIME(2)=TRUE
#ISPRIME(7)=TRUE
#ISPRIME(105)=FALSE
#ISPRIME(1)=TRUE
#ISPRIME(-2)=FALSE
#ISPRIME(0)=FALSE
==See Also==
*[[Manuals/calci/ISNUMBER | ISNUMBER ]]
*[[Manuals/calci/ISODD | ISODD ]]
*[[Manuals/calci/ISEVEN | ISEVEN ]]
==References==