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 | $ |