Difference between revisions of "Manuals/calci/LISTPRIMES"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''LISTPRIMES'''(max,min,i) where '''max''','''min''' and''' i '''are any real numbers </div> ---- <div id...") |
|||
Line 1: | Line 1: | ||
− | <div | + | <div style="font-size:30px">'''LISTPRIMES(max,min,i)'''</div><br/> |
+ | *<math>max</math> is the upper limit,and | ||
+ | * <math>min</math> is the lower limit and i is the <math> i</math>'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 <math> LISTPRIMES(max,min,i)</math>, gives the list of prime numbers between the range <math> max </math> and <math>min</math>. | ||
+ | *<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. | ||
+ | *Suppose we are not giving the ith value, it will show all the prime numbers in given ange. | ||
+ | *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>. | ||
where | where |
Revision as of 02:42, 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 ange.
- 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.>math>max </math> or .
where
max,min and i are any real numbers
LISTPRIMES function returns prime numbers in the given range .It returns the ith prime number in the given range if i is given.
LISTPRIMES returns NaN if any of max,min or i are not real numbers.
LISTPRIMES
Lets see an example in (Column2Row1)
=LISTPRIMES(Column1Row1,Column1Row2)
Returns 2,3,5,7 for LISTPRIMES(10,2)
Consider another example in (Column2Row4)
=LISTPRIMES(Column1Row4,Column1Row5,Column1Row6)
Returns 3 for LISTPRIMES(10,2,2)
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 10 | 2,3,5,7 | ||
Row2 | 2 | |||
Row3 | ||||
Row4 | 10 | 3 | ||
Row5 | 2 | |||
Row6 | 2 |
File:Calci1.gif | $ |