Excel functions / Math
SQRTPI function
The square root of a number multiplied by π.
Syntax
=SQRTPI(number)
Arguments
number: A number that is 0 or more.
When to use it
SQRTPI gives the square root of a number multiplied by π, a quantity that appears in statistics and physics formulas.
Examples
The square root of 2π
A B C 1 x 2 2 2.5066 In C2:
=SQRTPI(A2)→ 2.5066
Common mistakes
- Negative numbers. SQRTPI of a negative number is #NUM!.
SQRTPI in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SQRTPI
- Danish: KVRODPI
- Dutch: WORTEL.PI
- Finnish: NELIÖJUURI.PII
- French: RACINE.PI
- German: WURZELPI
- Hungarian: GYÖKPI
- Italian: RADQ.PI.GRECO
- Norwegian: ROTPI
- Polish: PIERW.PI
- Portuguese (Brazil): RAIZPI
- Portuguese (Portugal): RAIZPI
- Russian: КОРЕНЬПИ
- Spanish: RAIZ2PI
- Swedish: ROTPI
- Turkish: KAREKÖKPİ