Difference between revisions of "Manuals/calci/LISTPRIMES"

From ZCubes Wiki
Jump to navigation Jump to search
Line 12: Line 12:
 
*<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.
+
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
+
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>.
+
3.<math>max </math> or <math> min<0</math>.
  
where
+
==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
  
'''max''','''min''' and''' i '''are any real numbers
+
==See Also==
 
+
*[[Manuals/calci/INT | INT]]
</div>
+
*[[Manuals/calci/EVEN  | EVEN ]]
----
+
*[[Manuals/calci/ODD  | ODD ]]
<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="even"
 
| 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:italic.gif]]
 
|
 
[[Image:normal.gif]]
 
|
 
[[Image:underline.gif]]
 
|
 
[[Image:border.gif]]
 
|
 
[[Image:numbers.gif]]
 
|
 
[[Image:sort.gif]]
 
|
 
[[Image:formatcells.gif]]
 
|
 
[[Image:graphs.gif]]
 
| $
 
|}
 
 
 
</div>
 
----
 

Revision as of 02:50, 19 December 2013

LISTPRIMES(max,min,i)


  • is the upper limit,and
  • is the lower limit and i is the 'th position of a prime number.

Description

  • This function is listing the set of prime numbers for the given set of numbers.
  • 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. Such numbers are called composite numbers.
  • Also the number 0 and 1 are neither prime nor composite.
  • In , gives the list of prime numbers between the range and .
  • is the upper limit value and is the lower limit value
  • And is the position of the prime number value. value is optional.
  • 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

1. any one of the argument is nonnumeric. 2. or is the beyond the range number of prime numbers 3. or .

Examples

  1. LISTPRIMES(20,11)=11 13 17 19
  2. LISTPRIMES(20,11,3)=17
  3. LISTPRIMES(150,130)=131,137,139,149
  4. LISTPRIMES(10,-1)=2 3 5 7
  5. LISTPRIMES(-10,1)=Null
  6. LISTPRIMES(90,70)=71 73 79 83 89
  7. LISTPRIMES(90,70,4)=83
  8. LISTPRIMES(90,70,6)=Null

See Also