Returns the square root of a positive number.
Синтаксис
SQRT(number)Аргументы
numberобязательно
The number for which you want to calculate the square root.
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)→4Returns the square root of 16.
=SQRT(A1)→5Returns the square root of the value in cell A1 (assuming A1 contains 25).
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =SQRT( followed by the number or cell reference, then close with a parenthesis.
Press Enter
Press the Enter key to calculate the square root.
The function will return a #NUM! error because the square root of a negative number is not a real number.