How does Excel open an n-square root for a number of times?

How does Excel open an n-square root for a number of times?

Open square root

Notice I'm just asking for a non-negative arithmetic square root (a positive number has two square roots, where the arithmetic square root is greater than 0).

Method one, using the "power" function

For example, to find the arithmetic square root of A1 cell, simply enter the formula "=power (a1,0.5)" (not quotes) in the B1 cell

See figure below

Related tutorials: Excel uses the SUBTOTAL function to implement cell hiding

Method Two

For example, to find the arithmetic square root of A2 cell, simply enter the formula "=a2^0.5" in the B2 cell (do not quote)

See figure below

Open Root

Method one, using the "power" function

For example, to find the cube root of cell A1, simply enter the formula "=power (A1, (1/3))" In the B1 cell (no quotes)

See figure below

Method Two

For example, to find the cube root of cell A2, simply enter the formula "=a2^ (1/3)" (no quotes) in the B2 cell

See figure below

Open N-square root (N>=2,n is a positive integer)

Method one, using the "power" function

For example, to find the N-square root of A1 cells, simply enter the formula "=power (A1, (1/n))" In the B1 cell (no quotes)

Method Two

For example, to find the N-square root of A2 cells, simply enter the formula "=a2^ (1/n)" (not quotes) in the B2 cell

WPS Tutorial

Word Tutorial

Excel Tutorials