What is the syntax for SQRTPI in Excel?

The syntax for SQRTPI is: =SQRTPI(number)

How do I use the SQRTPI function?

To use SQRTPI, type =SQRTPI( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if SQRTPI encounters errors?

If SQRTPI encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is SQRTPI not working in my Excel?

Common issues with SQRTPI include #NUM! if number is negative. Start by checking the syntax =SQRTPI(number), then verify each referenced cell or range.

Math & Trig

SQRTPI Function in Excel

Returns the square root of (number * pi).

Syntax

=SQRTPI(number)

Arguments

number (required): The number to multiply by pi before taking square root

Examples

=SQRTPI(1) - Square root of pi - Result: 1.7724539
=SQRTPI(2) - Square root of 2*pi - Result: 2.5066283

SQRTPI in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#NUM! if number is negative

Use cases

Statistical calculations
Scientific formulas
Engineering calculations

Frequently asked questions

What is the SQRTPI function in Excel? SQRTPI returns the square root of (number * pi). The syntax is =SQRTPI(number). Typical use cases include statistical calculations, scientific formulas, engineering calculations.
How do I use the SQRTPI function? To use SQRTPI, type =SQRTPI( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if SQRTPI encounters errors? If SQRTPI encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is SQRTPI not working in my Excel? Common issues with SQRTPI include #NUM! if number is negative. Start by checking the syntax =SQRTPI(number), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.