Article updated on February 15, 2018

The SQRT function calculates the positive square root.

Formula in cell C3:


Excel Function Syntax



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


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


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 […]