Practice free

SQRTPI function

SQRTPI returns the square root of a number multiplied by pi. It is a shortcut that turns up in statistics formulas, and a negative input returns #NUM!.

Example

Read it as a sentence: multiply 2 by pi, then find the square root, which gives 2.506628275.

Practice this in the app

Syntax

SQRTPI(number)

number (required)
A number zero or higher.

Returns: The square root of the number multiplied by pi.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=SQRTPI(0.5) 1.253314137 Positive
=SQRTPI(0) 0 Zero
=SQRTPI(2) 2.506628275 Larger value
=SQRTPI("0.5") 1.253314137 Text number "0.5"
=SQRTPI({0.1,0.2}) 0.560499122 Array constant spills
=SQRTPI(1) 1.772453851 1
=SQRTPI(-0.5) #NUM! Negative
=SQRTPI("abc") #VALUE! Non-numeric text

Watch out for

  • Negative input returns #NUM!.

Where it works

Excel
SQRTPI is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .