Returns the square root of a positive number.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
SQRT(number)The SQRT function calculates the positive square root of a given number. If the number is negative, the function returns a #NUM! error.
=SQRT(16)Result: 4
Returns the square root of 16.
=SQRT(A1)Result: 5
Returns the square root of the value in cell A1 (assuming A1 contains 25).
The function will return a #NUM! error because the square root of a negative number is not a real number.