The Excel SQRTPI Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Sqrtpi-Function

Search this site:

Custom Search

Related Function:

PI Function

Basic Description

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

I.e.

SQRTPI( number ) = SQRT( number * π )

The syntax of the Sqrtpi function is :

SQRTPI( number )

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

The following spreadsheet shows four examples of the sqrtpi function.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Formulas:

Results:

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

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 argument is < 0

#VALUE!

Occurs if the supplied number argument is non-numeric

#NAME?

Occurs when Analysis ToolPak add-in is not enabled in your Excel.
You will need to enable the add-in if you want to use the Excel Sqrtpi function.

To do this in Excel 2003 :

From the Tools drop-down menu, select the option Add-Ins ...
An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK

To do this in Excel 2007 or Excel 2010 :

Click the Microsoft button on the top left of your spreadsheet and select the Excel Options button
From the menu on the left hand side, select Add-Ins
In the 'Manage:' box, select Excel Add-ins and click Go...
An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK

Disclaimer