How to write in Radical Excel (second root)? (Step by step)

msrxp Excell September 28, 2020

The second root of a number is a value that, when multiplied by itself, gives the number. The SQRT function in Excel returns the second root of a number.

1. First, to get the square root of a number, multiply the number by itself. For example, 16 = 4 * 4 or 16 = 2.4%

$C: \ Users \ Mr \ Desktop \ square-a-number.png$

Tip: Press SHIFT and 6 to enter the symbol.

2- The second root is 16 times 4.

$C: \ Users \ Mr \ Desktop \ square-root.png$

3- Instead of using the SQRT function, you can also use a factor of 1/2. Do not forget the parentheses.

$C: \ Users \ Mr \ Desktop \ exponent-of-one-half.png$

4. If a number is negative, the SQRT function returns the error! NUM #.

$C: \ Users \ Mr \ Desktop \ num-error.png$

5. You can use the ABS function to remove the negative sign (-) from the negative number.

$C: \ Users \ Mr \ Desktop \ abs-function.png$

Excel has no internal functions for calculating the nth root of a number. To calculate the nth root of a number, simply multiply that number by 1.

6- For example, in 5 * 5 * 5 or 3.5, 5 has reached the power of three.

$C: \ Users \ Mr \ Desktop \ third-power.png$

7- The third root of 125 is equal to 5.

$C: \ Users \ Mr \ Desktop \ cube-root.png$

8. For example, 2 * 2 * 2 * 2 * 2 * 2 or 2.6 increases the number 2 to the power of 6.

$C: \ Users \ Mr \ Desktop \ sixth-power.png$

9- The sixth root is 64 times 2.

$C: \ Users \ Mr \ Desktop \ sixth-root.png$