Returns the positive square root.
Syntax
SQRT(number)
Number The number to calculate the square root of.
Description
If the parameter Number is a negative value, the function SQRT returns the error value #Num!.
The meaning of the SQRT function is Returns the positive square root, that is, using this function can help us calculate the square root of a number.
Things to note when using this function:
The value to be calculated as the square root must be a positive number, otherwise the error value #Num! will be returned
Let's operate it in this table to help everyone understand this function.
![图文对齐图.png 图文对齐图.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e1ea7da86ff61befb1c583b6784f105d.png)
■ Select cell B2, click Insert Function, find SQRT, and click OK.
In the pop-up window, we need to fill in the values.
![GIF1.gif GIF1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/886710fd5986ee2e989e4fe75d60faa3.gif)
■ Fill in A2, click OK, and the square root of the value will be calculated immediately.
Position the cursor to the lower right corner of B2, and when the cursor changes to a + font, pull down and fill in the cells to calculate the square root results of the data in batches.
![GIF3.gif GIF3.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/2f753789b58bc99ec84163173b124573.gif)
This function can help us save tedious calculations, learn it once and use it for life!
评论列表(196条)
测试