The Excel SQRTPI Function

Related Functions:
PI Function
SQRT Function

Basic Description

The Excel SQRTPI function returns the square root of a supplied number multiplied by the mathematical constant, π.

I.e.

SQRTPI( number ) = SQRT( number * π )

The syntax of the Sqrtpi function is:

SQRTPI( number )

Where the number argument is the positive numeric value, that you want to multiply by pi, before calculating the square root.


Sqrtpi Function Examples

The following spreadsheet contains four examples of the Sqrtpi function.

 Formulas:
 A
1=SQRTPI( 5 )
2=SQRTPI( 0.2 )
3=SQRTPI( 100 )
4=SQRTPI( 0 )
 Results:
 A
13.963327298
20.79266546
317.72453851
40

Further details and examples of the Excel Sqrtpi function are provided on the Microsoft Office website.


Sqrtpi Function Errors

If you get an error from the Excel Sqrtpi Function, this is likely to be one of the following:

Common Errors
#NUM!-Occurs if the supplied number is < 0.
#VALUE!-Occurs if the supplied number argument is non-numeric.