What is the formula for square root

ROOT (function)

This article discusses the formula syntax and usage of the ROOT described in Microsoft Excel.

description

Returns the square root of a number.

syntax

ROOT (number)

The ROOT function syntax has the following arguments:

  • number Required. The number whose square root you want to calculate

Note

If "number" is negative, ROOT returns the #NUM! back.

example

Copy and paste the sample data in the following table into cell A1 of a new Excel worksheet. To see the results of the formulas, highlight them, press F2, and then press ENTER. If necessary, you can adjust the width of the columns so that all data is displayed.

Data

-16

formula

description

Result

= ROOT (16)

The square root of 16

4

= ROOT (A2)

The square root of -16. Since the number is negative, the #NUM! returned.

#NUMBER!

= ROOT (ABS (A2))

The #NUM! is avoided by first calculating the absolute value of -16 with the ABS function and only then calculating the square root.

4