Manuals/calci/LISTPRIMES

LISTPRIMES(max,min,i)

• $max$ is the upper limit.
• $min$ is the lower limit and i is the $i^{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 $LISTPRIMES(max,min,i)$, gives the list of prime numbers between the range $max$ and $min$.
• $max$ is the upper limit value and $min$ is the lower limit value
• And $i$ is the position of the prime number value. $i$ 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. $max<min$ or $i$ is the beyond the range number of prime numbers
3. $max$ or $min<0$.

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

• INT
• EVEN
• ODD

References

Prime Numbers