Home >Topics >excel >How to find the root number in excel

How to find the root number in excel

藏色散人
藏色散人Original
2019-06-04 13:34:0335607browse

How to find the root number in excel

#How to open the root number in excel?

There are many ways to open the root number in Excel tables.

Here is a method commonly used by the author, which is to enter "= (value or expression)^(1/square root)" in the function bar. The actual operation is as follows:

1. Create a new Excel table and enter certain data for the convenience of demonstration, as shown below.

How to find the root number in excel

2. Suppose we want to calculate "the result of raising the sum of A1 and B1 to the power of 2" at D1, then select cell D1, as shown below.

How to find the root number in excel

3. Enter "=(A1 B1)^(1/2)" in the function bar above, and then press the Enter key to get the result, as shown below.

How to find the root number in excel

#4. Change the number of the square root to how many times it is raised. For example, change the previous step to the fourth power, as shown below.

How to find the root number in excel

The above is the detailed content of How to find the root number 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