Article updated on May 04, 2018

The SQRT function calculates the positive square root.

Formula in cell C3:

=SQRT(B3)

Excel Function Syntax

SQRT(number)

Arguments

number Required. The positive numerical value for which you want the square root.

Comments

Use the ABS function to remove the sign if a number is negative.

=SQRT(ABS(-5))

How to use the ABS function

Converts negative numbers to positive numbers, in other words, the ABS function removes the sign. Excel Function Syntax ABS(number) Arguments […]