Slider

How to Extract the Root of a Number in Excel 2016

Date:2019-8-6 Author:Cordelia

While processing data in Excel, sometimes we may need to extract the roots of numbers. At this point, you can insert a function to do the operation.

For example, I want to extract the cube root of 3375. Type the number in A1 and input the formula “=3375^(1/3)” in half-angle.

How to Extract the Root of a Number in Excel 2016

Then press [Enter] key or click any place outside the cell. The result will be worked out immediately

How to Extract the Root of a Number in Excel 2016

Similarly, if you want to extract the fifth root of it, then the formula should be “=3375^(1/5)“.

How to Extract the Root of a Number in Excel 2016

Input it in C2 and press [Enter] to work it out.

How to Extract the Root of a Number in Excel 2016

You can extract the sixth root, the seventh root, etc. in this way. Just adjust the formula to meet your need.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *