# 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

 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.