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.
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:
Based on the Excel spreadsheet above, the following SQRTPI examples would return:
- #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.