SQRT(number)

Returns the positive square root of a number.

numberThe number you want to find the square root of.

Remarks

* 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 SQR
* For the Microsoft documentation refer to support.office.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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top