Manuals/calci/LISTPRIMES

LISTPRIMES (Max,Min,IndexOnly)

• is the upper limit.
• is the lower limit.
• is the specified position of a prime number.
• LISTPRIMES(),returns the list of prime numbers from given range

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 Index 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 .

ZOS

• The syntax is to display the prime numbers list in ZOS is .
• is the upper limit.
• is the lower limit.
• is the specified position of a prime number.
• For e.g.,LISTPRIMES(500,390,7)
Listing Prime Numbers

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) = undefined

PRIME NUMBERS