June 18, 2021

How to use the Excel SQRTPI function

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:

SQRTPI function - How to use the Excel SQRTPI function

Syntax:  =SQRTPI(A2)


Excel SQRTPI function - How to use the Excel SQRTPI function

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


  • #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.
READ:  How to use the Excel PI function

Leave a Reply

Your email address will not be published. Required fields are marked *