Manuals/calci/LISTPRIMES

Revision as of 16:17, 25 June 2018 by Devika (talk | contribs)
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) = Null

Related Videos

PRIME NUMBERS

See Also

References

Prime Numbers