Manuals/calci/LISTPRIMES

Revision as of 00:15, 26 December 2013 by Abin (talk | contribs) (→‎Examples)
LISTPRIMES(max,min,i)


  • is the upper limit.
  • is the lower limit and i is the 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 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  .

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

References