SQRTPI in Excel: Take the Square Root of Pi Times a Number

• Introduced: First introduction version is not established by the official history reviewed.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official SQRTPI reference. Documentation and independently calculated examples; no native Excel execution or broader platform certification.

=SQRTPI(number)

The one required number is multiplied by pi before the square root is taken. Microsoft documents #NUM! for a negative input. Examples here use nonnegative finite values and English function names.

This is a real-valued square-root operation. The expected output has the nonnegative sign; it does not return a pair of positive and negative roots. A complete text-conversion or complex-input policy is not established by the short dedicated reference.

Enter 0, 1, 4 and 9 in A2:A5. Fill =SQRTPI(A2) down.

Zero follows the independently derived mathematical boundary. The positive inputs give one, two and three times the square root of pi because their square roots are one, two and three.

Keep unrounded results for later calculations. The nine displayed decimal places are a presentation choice, not a guarantee of native stored precision in every Excel release.

=SQRTPI(4)
=SQRT(4*PI())
=PI()*SQRT(4)

Expected values are 3.544907702, 3.544907702 and 6.283185307 approximately. The first two expressions represent the same mathematical operation, while the third places pi outside the root and answers a different question.

SQRT and PI make the construction explicit. Parentheses and operation order matter more than a superficial similarity between function names.

For a circle of area A, radius is SQRT(A/PI()) and circumference is 2×PI()×radius. Substitution gives the equivalent expression 2×SQRT(A×PI()). With fictional area 25 square units:

=2*SQRTPI(25)

Expected circumference: approximately 17.724538509 length units. The corresponding radius is approximately 2.820947918. This is a circle model; the same area does not fix a unique perimeter for an arbitrary shape.

The square root changes the dimensional scale from area to length. Multiplying by a dimensionless pi does not convert incompatible source units, so make the unit of the entered area explicit.

For a nonnegative input x, multiplying x by four doubles SQRTPI(x). At x=9:

=SQRTPI(9)
=SQRTPI(36)

Expected values are approximately 5.317361553 and 10.634723105. Increasing the input by a factor of four does not multiply the result by four. This matters when interpreting changes in an area-like quantity.

Squaring the unrounded second result and dividing by PI() mathematically reconstructs 36. Reusing only the printed decimal digits can produce a small residual, so compare with a justified tolerance rather than assuming displayed values preserve every original bit.

SQRTPI(−1) has a documented #NUM! expectation. Replacing a negative source with its absolute value would change the input model and can conceal a sign error; do not apply that transformation merely to remove an error display.

The controls are independently calculated finite examples. Native overflow, very small underflow, imported text and cross-version precision are not certified by these identities. Keep the raw argument beside the result when investigating an unexpected output.

• Microsoft SQRTPI reference.
• Editorial testing standards.

Worked inputs are fictional. Decimal answers are independently calculated mathematical expectations rounded to nine places, not captured native results. Extreme magnitudes, complete coercion matrices and cross-version numerical accuracy remain untested.