SQRTPI Function in Excel: Square Root of x Times Pi

SQRTPI Function in Excel: Square Root of x Times Pi 1
⏱ 1 min readUpdated 5 October 2026

Maths & trigLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. SQRTPI in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

SQRTPI returns SQRT(x*PI()), which turns up in statistics and physics formulas.

Advertisement

Syntax

=SQRTPI(number)
Argument What it means
number Non-negative

Examples

Example 1

=ROUND(SQRTPI(A2),5)

Result: 1.77245. See the worked example table below for more cases.

SQRTPI in practice

Where you will use it

  • Normal-distribution constants
  • Physics formulas
  • Coursework

Worked example

xFormulaResult
1=ROUND(SQRTPI(A2),5)1.77245
2=ROUND(SQRTPI(A3),5)2.50663
100=ROUND(SQRTPI(A4),5)17.72454

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Negative input#NUM!
Confusing with SQRT(PI())SQRTPI(1) = SQRT(PI())

SQRT · PI

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZREGISTER.ID Function in Excel: ID of a Registered DLL FunctionExcel Functions A–ZTINV Function in Excel: Two-Tailed t Critical Value (Older Name)Excel Functions A–ZF.INV.RT Function in Excel: F Critical Value
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong