Purpose
Return value
Syntax
=SQRTPI(number)- number - A positive number to multiply by π before taking the square root.
Using the SQRTPI function
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.
=SQRTPI(1) // returns 1.77245385090552 (square root of π)If the number argument is negative, SQRTPI returns a #NUM! error. If the number argument is not numeric, SQRTPI returns a #VALUE! error.
Basic Examples
=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:
=SQRTPI(9) // 5.31736155271656
=SQRT(9*PI()) // 5.31736155271656 (equivalent)
Error Handling
The SQRTPI function will return errors in the following cases:
- #NUM! error: When the number argument is negative
- #VALUE! error: When the number argument is not numeric
=SQRTPI(-1) // Returns #NUM! error
=SQRTPI("text") // Returns #VALUE! error
=SQRTPI(TRUE) // Returns #VALUE! error
Related functions
PI Function
The Excel PI function returns the value of the geometric constant π (pi). The value represents a half-rotation in the radian angle system. The constant appears in many formulas relating the circle, such as the area of a circle....
SQRT Function
The Excel SQRT function returns the square root of a positive number. SQRT returns an error if number is negative.
