Manuals/calci/LISTPRIMES

Revision as of 02:50, 19 December 2013 by Devika (talk | contribs) (→‎Description)
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 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