|
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.

For this data set, the formula returns 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.

For this data set, the formula returns #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.

For this data set, the formula returns 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

ABS
EXP
LN
MOD
N
POWER
PRODUCT
SIGN
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT

Was this article helpful?
0 out of 0 found this helpful
Description Use this function to return the square root of a positive number. Supported in Chains.  SyntaxSQRT(number...