Refer PN.NEXT in the below link

http://xcell05.free.fr/morefunc/english/

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hello,

I would like a function which I could aks for the nth prime number. e.g.

=myfunction(10)

which would give the tenth prime.
Also I would like a function/formula that would test a number for being a
prime.

Thank you