ID EN
…
#Math

SQRTPI

Excel Functions

Get the square root of (number × π)

Syntax

EXCEL 
=SQRTPI(number)

Arguments

Parameter Description
number A positive number to multiply by π before taking the square root.

Return Value

A positive number.

Details

The SQRTPI function calculates the square root of (number × π). This is equivalent to SQRT(number*PI()) but provides a more direct way to perform this calculation. The function returns a numeric value accurate to 15 digits. If the number argument is negative, SQRTPI returns a #NUM! error. If the number argument is not numeric, SQRTPI returns a #VALUE! error. The SQRTPI function provides the same result as combining the SQRT and PI functions: The SQRTPI function will return errors in the following cases:

Examples

Example 1

The SQRTPI function calculates the square root of (number × π). This is equivalent to SQRT(number*PI()) but provides a more direct way to perform this

EXCEL 
=SQRTPI(1) // returns 1.77245385090552 (square root of π)
Basic Examples
EXCEL 
=SQRTPI(1) // returns 1.772453851 (square root of π)
=SQRTPI(4) // returns 3.544907702 (square root of 4π)
Comparison with Equivalent Formula

The SQRTPI function provides the same result as combining the SQRT and PI functions:

EXCEL 
=SQRTPI(9) // 5.31736155271656
=SQRT(9*PI()) // 5.31736155271656 (equivalent)
Error Handling
EXCEL 
=SQRTPI(-1) // Returns #NUM! error
=SQRTPI("text") // Returns #VALUE! error
=SQRTPI(TRUE) // Returns #VALUE! error

See Also

PI SQRT