Function Math Arithmetic Class

NextPrime

"Next Prime Number" Returns the next larger prime number. Returns the smallest prime number greater than the argument.

Signature (Visual Basic / VBA)

Public Function NextPrime( _
    ByVal vX As Variant _
    ) As Variant

Code Examples

    NextPrime(-6) = -5
    NextPrime(-5) = -3
    NextPrime(-3) = -2
    NextPrime(-2) = 2
    NextPrime(-1) = 2
    NextPrime(1) = 2
    NextPrime(2) = 3
    NextPrime(3) = 5
    NextPrime(5) = 7
    NextPrime(7) = 11
    If -5 <= X < -3 Then Return -3.
    If -3 <= X < -2 Then Return -2.
    If -2 <= X <  2 Then Return  2.
    If  2 <= X <  3 Then Return  3.

Parameters

Parameter Description
vX The number whose next-larger prime number is returned. Function returns Null if vX is Null or cannot be fixed up to a number.