|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Workiva Support Center

SQRT

SQRT

  • Last updated on

Description

Use this function to return the square root of a positive number. Supported in Chains.

 

Syntax

SQRT(number)

 

Inputs

This function has the following arguments:

Name Required Description Valid input
number Yes The number whose root is to be extracted. A cell reference, a number, or a formula which results in either of these.

 

Examples

Sample data

A B
1

34

0
2

-2

39

Sample formulas

Use case Formula Explanation and Result
Calculate the square root of a positive number. =SQRT(4)

This formula works in the following manner:

  • SQRT(: This is the function itself, which returns the square root of a number.
  • 4: The number argument.
  • The function returns the square root of 4.

Result: 2.
Calculate the square root of a negative number in a cell. =SQRT(A2)

This formula works in the following manner:

  • SQRT(: This is the function itself.
  • A2: The number argument, referencing A2 (which contains -2).
  • The function cannot calculate the square root of a negative number.

Result: #NUM!.
Calculate the square root of zero in a cell. =SQRT(B1)

This formula works in the following manner:

  • SQRT(: This is the function itself.
  • B1: The number argument, referencing B1 (which contains 0).
  • The function returns the square root of 0.

Result: 0.

Notes

  • If number isn't numeric, SQRT returns a #VALUE! error.
  • If number is negative, SQRT returns a #NUM! error.
  • Wildcards don't work with this function.

 

Related functions

DescriptionUse this function to return the square root of a positive number. Supported in Chains. SyntaxSQRT(number) ...