SQRT

SQRT(number)

Returns the positive square root of a number.

number

The number you want to find the square root of.

REMARKS

* This function can return multiple values.
* If "number" < 0, then #NUM! is returned.
* If "number" is not numeric, then #VALUE! is returned.
* You can also calculate the square root of a number by raising it the power of one half, for example "16^0.5 = 4".
* You can use the POWER function to return a number raised to a given power.
* You can use the SQRTPI function to return the square root multiplied by PI.
* You can use the SUMSQ function to return the sum of the squares.
* The equivalent VBA function is VBA.SQR
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=SQRT(16) = 4
2	=SQRT(ABS(-16)) = 4
3	=SQRT(4*4) = 4
4	=POWER(16, 0.5) = 4
5	=POWER(16, 1/2) = 4
6	=16^(1/2) = 4
7	=16^0.5 = 4
8	=SQRT(25) = 5
9	=SQRT(100) = 10
10	=SQRT(0) = 0
11	=SQRT(-16) = #NUM!
12	=SQRT("some text") = #VALUE!

1 - What is the square root of 16.
2 - What is the square root of 16. You must convert any negative numbers to positive numbers first.
3 - What is the square root of 16.
4 - What is the square root of 16 using the POWER function.
5 - What is the square root of 16 using the POWER function.
6 - What is the square root of 16 using a formula. The "^" operator can be used instead of the POWER function.
7 - What is the square root of 16 using a formula. The "^" operator can be used instead of the POWER function.
8 - What is the square root of 25.
9 - What is the square root of 100.
10 - What is the square root of 0.
11 - What is the square root of a negative number.
12 - What is the square root of a non numerical value.