PrecisionCalc
xl
Precision
Get Your Numbers Right

 

xlpISPRIME

Determines whether a number is prime, with up to 32,767 significant digits of precision. Returns TRUE if number is prime; returns FALSE if not. Returns #NUM! if input cannot be resolved to a valid integer.

Caution: using xlpISPRIME on large numbers can take hours or days or longer to calculate.

Requires the 5,000 SD edition of xlPrecision or higher, or the Free Edition.

 

xlpISPRIME was introduced in xlPrecision 2018. It is not included in versions 3.x.x and earlier.

 

Syntax

xlpISPRIME(num)

num Required. The number to determine whether it is prime.

Remarks

Examples

Formula Description Result
=xlpISPRIME(7) Determines whether 7 is prime TRUE
=xlpISPRIME(4) Determines whether 4 is prime FALSE
=xlpISPRIME(3.2) Determines whether 3.2 is prime #NUM! (error because 3.2 is not an integer)
=xlpISPRIME("abc") Determines whether "abc" is prime #NUM! (error because "abc" is not an integer)