The SQRTPI function in MS Excel is used to calculate the square root of a given numeric value multiplied by the value of Pi. The supplied numeric value is multiplied first with the value of Pi before getting the square root.
Syntax: =SQRTPI(number)
SQRTPI( number ) = SQRT( number * π )
The SQRTPI function syntax has the following arguments:
- Number– positive numeric value for which SQRTPI needs to be calculated
Example: Let’s look at some Excel SQRTPI function examples and explore how to use the SQRTPI function as a worksheet function in Microsoft Excel:
Syntax: =SQRTPI(A2)
Result:
Based on the Excel spreadsheet above, the following SQRTPI examples would return:
Syntax: =SQRTPI(A3)
Result: 7.089815404
Syntax: =SQRTPI(A4)
Result: 35.44907702
Syntax: =SQRTPI(A5)
Result: 53.17361553
Syntax: =SQRTPI(A6)
Result: 10.63472311
Syntax: =SQRTPI(A7)
Result: 12.40717696
Syntax: =SQRTPI(A8)
Result: 28.35926161
Syntax: =SQRTPI(A9)
Result: 21.26944621
Syntax: =SQRTPI(A10)
Result: 19.49699236
Syntax: =SQRTPI(A12)
Result: #NUM!
Syntax: =SQRTPI(A13)
Result: #NUM!
Syntax: =SQRTPI(ABS(A14))
Result: 21.26944621
Note:
- #NUM!: This result is displayed if the supplied numeric value is less than 0.
- #VALUE!: This result is displayed if you have entered a non-numeric value.
- #NAME!: This result is displayed when the Analysis ToolPak add-in is not activated in your Excel spreadsheet. You are required to activate the add-in before you can use the SQRTPI function in MS Excel.