Quick Navigation

SQRTPI Function

Excel 2007+

Summary

The Excel SQRTPI function calculates the square root of (number × π), providing a direct way to compute this common mathematical operation without separate multiplication and square root functions.

Syntax

SQRTPI(number)

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	The number by which π is multiplied. Must be non-negative.

Using the SQRTPI Function

SQRTPI simplifies calculations involving circular measurements and trigonometric applications. Use it when you need the square root of a value scaled by π, such as in formulas for circle areas, wave calculations, or statistical distributions.

Common SQRTPI Examples

Basic SQRTPI Calculation

=SQRTPI(1)

Returns square root of π (1.772454) - radius equivalent of unit circle area.

Area to Radius Conversion

=SQRTPI(A1)

Converts circle area in A1 to radius. If A1=10, returns radius ≈2.256.

Frequently Asked Questions

SQRTPI returns #NUM! error for negative values since square root of negative numbers is undefined.

Yes: SQRTPI(number) = SQRT(number*PI()), but SQRTPI is more efficient and readable.

Common Errors and Solutions

#NUM! Error

Cause: Input number is negative

Solution: Use ABS() function or ensure positive input: =SQRTPI(ABS(A1))

Notes

π ≈ 3.14159265359 is used internally
Result precision matches Excel's PI() function
Consider using PI() function explicitly for transparency in complex formulas

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+