The Excel SQRTPI function returns the square root of a supplied number multiplied by the mathematical constant, π.
I.e.
The syntax of the Sqrtpi function is:
Where the number argument is the positive numeric value, that you want to multiply by pi, before calculating the square root.
The following spreadsheet contains four examples of the Sqrtpi function.
|
Formulas:
|
Results:
|
Further 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:
| #NUM! | - | Occurs if the supplied number is < 0. |
| #VALUE! | - | Occurs if the supplied number argument is non-numeric. |