What is the function formula to open the root sign in Excel?

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!