PrecisionCalc
xl
Precision
Get Your Numbers Right

 

xlpSQRTPI

Gets the square root of a positive number multiplied by Pi, with up to 32,767 significant digits of precision. Same as Excel's built-in SQRTPI function, but with high precision.

Syntax

xlpSQRTPI(num,format_thousands,format_currency,exponential_notation,maximum_significant_digits)

num Required. The number for which the square root will be found after multiplying by Pi. Must be positive. Can be a non-integer.
format_thousands Optional. Determines whether thousands separators are included. Set to TRUE to include thousands separators. FALSE by default.
format_currency Optional. Determines whether currency symbol is included. Set to TRUE to include currency symbol. The currency symbol will be added either to the beginning or to the end of the result, whichever is appropriate for the locale. FALSE by default.
exponential_notation Optional. Determines whether result is formatted in exponential notation. Set to TRUE to format in exponential notation. FALSE by default.
maximum_significant_digits Optional. Determines the maximum number of significant digits to be returned. Default is 100, or the user's custom maximum set in the About box, or the maximum number allowed by the edition of xlPrecision, whichever is less.

Remarks

Examples

Formula Description Result
=xlpSQRTPI(5) 2 (5 x Pi) 3.963327297606011013345029
(Length depends on xlPrecision edition)
=xlpSQRTPI(-5) 2 (-5) #NUM!
=xlpSQRTPI(5,,,,25) 2 (5 x Pi), limited to 20 significant digits 3.9633272976060110133

See Also

xlpROOT
xlpSQRT
xlpPI