What is the function formula to open the root sign in Excel?
- 藏色散人Original
- 2019-06-13 09:12:2069543browse
The following are several ways to use formulas to open the root sign in excel:
For example: Find the square root of 27 in cell A1
Method 1: Enter =sqrt(A1)
Method 2: Enter the formula =A1^(1/2 )
Both methods can be used to find the square root
Extended information:
Find the cubic root
Use Formula =A1^(1/3)
The cubic root of 27, the result is 3.
Similarly find the fourth power, the formula =A1^(1/4).
The square root function can be found using the above method.
For more Excel related tutorials, please visit the Excel Basic Tutorial column!
The above is the detailed content of What is the function formula to open the root sign in Excel?. For more information, please follow other related articles on the PHP Chinese website!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to display ##### in excelNext article：How to display ##### in excel