writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: − + − *1. any one of the argument is nonnumeric.+ − *2.<math> max < min </math> or <math>i </math> is the beyond the range number of prime numbers+ − *3.>math>max </math> or <math> min<0</math>.+ − where+ + + + + + + + + − '''max''','''min''' and''' i '''are any real numbers+ − + − </div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left"> − − LISTPRIMES function returns prime numbers in the given range .It returns the ith prime number in the given range if i is given. − − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − LISTPRIMES returns NaN if any of max,min or i are not real numbers. − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − LISTPRIMES − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column2Row1) − − <nowiki>=LISTPRIMES(Column1Row1,Column1Row2)</nowiki> − − Returns 2,3,5,7 for LISTPRIMES(10,2) − − Consider another example in (Column2Row4) − − <nowiki>=LISTPRIMES(Column1Row4,Column1Row5,Column1Row6)</nowiki> − − Returns 3 for LISTPRIMES(10,2,2) − − </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 − | class=" " | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | 10 − | class="sshl_f" | 2,3,5,7 − | class=" sshl_f" | − | class="sshl_f sshl_f " | − − | class=" " | Row2 − | 2 − | class="sshl_f " | − | class=" sshl_f" | − | class="sshl_f sshl_f " | − |- class="odd" − | Row3 − | − | class="sshl_f " | − | class="sshl_f " | − | class="sshl_f " | − |- class="even" − | Row4 − | class=" " | 10 − | class="sshl_f" | 3 − | class="sshl_f " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | 2 − | class=" 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=" " | − |- class="even" − | Row6 − | class="sshl_f " | 2 − | class=" " | − | class="sshl_f " | − | class=" " | − |} − − {| − | <span align="left">[[Image:calci1.gif]]</span> − − | − [[Image:bold.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/LISTPRIMES (view source)
Revision as of 08:50, 19 December 2013
, 08:50, 19 December 2013→Description
*<math>max </math> is the upper limit value and <math> min</math> is the lower limit value
*<math>max </math> is the upper limit value and <math> min</math> is the lower limit value
*And <math> i</math> is the position of the prime number value. <math>i</math> value is optional.
*And <math> i</math> is the position of the prime number value. <math>i</math> value is optional.
*Suppose we are not giving the ith value, it will show all the prime numbers in given ange.
*Suppose we are not giving the ith value, it will show all the prime numbers in given range.
*This function will give the result as error when
*This function will give the result as error when
1. any one of the argument is nonnumeric.
2.<math> max < min </math> or <math>i </math> is the beyond the range number of prime numbers
3.<math>max </math> or <math> min<0</math>.
==Examples==
#LISTPRIMES(20,11)=11 13 17 19
#LISTPRIMES(20,11,3)=17
#LISTPRIMES(150,130)=131,137,139,149
#LISTPRIMES(10,-1)=2 3 5 7
#LISTPRIMES(-10,1)=Null
#LISTPRIMES(90,70)=71 73 79 83 89
#LISTPRIMES(90,70,4)=83
#LISTPRIMES(90,70,6)=Null
==See Also==
*[[Manuals/calci/INT | INT]]
*[[Manuals/calci/EVEN | EVEN ]]
*[[Manuals/calci/ODD | ODD ]]
|- class="even"
|
[[Image:italic.gif]]
|