Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
SQRTPI
Returns the square root of a number multiplied by pi.
Rarely usedDifficulty 1250 · ProficientUsage rank #289 of 520
When to use it
Square root of (number × pi). Appears in the normal distribution's constants.
The shape of it
- Syntax
=SQRTPI(number)
Worked examples
One
=SQRTPI(1) → 1.772453851
The square root of pi.
Two
=SQRTPI(2) → 2.506628275
Square root of 2 pi, the normal density constant.
Four
=SQRTPI(4) → 3.544907702
Twice the square root of pi.
Worth knowing
- The normal density is EXP(-z^2/2)/SQRTPI(2).
- Same as SQRT(x*PI()).
- Input must be non-negative.
Where it goes wrong
- #NUM! for negative input.
- Rarely needed; NORM.DIST already includes the constant.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.