ReferenceFunctionsMath Functions

SQRTPI

SQRTPI: Returns the square root of a number multiplied by pi.

Summary

Returns the square root of a number multiplied by pi.

Remarks

Computes SQRT(number * PI()).
number must be greater than or equal to 0; otherwise returns #NUM!.
Input errors are propagated.

Examples

Square root of pi

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1.772453850905516

Scale before taking square root

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

3.544907701811032

FAQ

When does SQRTPI return #NUM!?

It returns #NUM! when the input is negative, because number*PI must be non-negative.

Runtime metadata

Category

Math

Signature

SQRTPI(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

SQRT

SQRT: Returns the positive square root of a number.

SUM

SUM: Adds numeric values across scalars and ranges.

On this page

Summary Remarks Examples Related functions FAQ When does SQRTPI return #NUM!?Runtime metadata