Manuals/calci/LISTPRIMES

Revision as of 02:42, 19 December 2013 by Devika (talk | contribs)
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 ange.
  • 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.>math>max </math> or  .

where

max,min and i are any real numbers


LISTPRIMES function returns prime numbers in the given range .It returns the ith prime number in the given range if i is given.


LISTPRIMES returns NaN if any of max,min or i are not real numbers.


LISTPRIMES


Lets see an example in (Column2Row1)

=LISTPRIMES(Column1Row1,Column1Row2)

Returns 2,3,5,7 for LISTPRIMES(10,2)

Consider another example in (Column2Row4)

=LISTPRIMES(Column1Row4,Column1Row5,Column1Row6)

Returns 3 for LISTPRIMES(10,2,2)


Syntax

Remarks

Examples

Description