Formualizer Docs
ReferenceFunctionsMath Functions

SQRT

SQRT: Returns the positive square root of a number.

Summary

Returns the positive square root of a number.

Remarks

  • Input must be greater than or equal to zero.
  • Negative input returns #NUM!.

Examples

Square root of a perfect square
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
12
Square root from a reference
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
1.4142135623730951

FAQ

When does SQRT return #NUM!?

It returns #NUM! for negative inputs because real square roots are undefined there.

Runtime metadata

Category

Math

Signature

SQRT(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

SINH

SINH: Returns the hyperbolic sine of a number.

SQRTPI

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does SQRT return #NUM!?Runtime metadata