How 2 find cube root using excel

To get the cube root of a number, you can use the caret(^) operator with 1/3 as the exponent in a simple formula. In the example shown, the formula in C5 is. Open an Excel file; Let's find the square root of a number; Here the number is ; The formula is; Square root formula=POWER(E3,1/2). When we use the. How to find square, cube, and nth roots in Excel using exponents and functions in formulas, with a step by step example included.

The trick is to realize that finding the cube root is the same as raising a So you find a cube root of the number in cell A1 using a formula like. For a Microsoft Excel 97 and earlier version of this article, see This step -by-step article shows you how to find the nth root of a number. Hi Does anyone know how to perform the cube root function in excel? By the way I did do a search for cube root & got The best way to search for Excel issues is to download Ron de Bruin's add-in for searching newsgroup.

A2^(1/3) tbh_29 wrote: > Any one know how i can do cube roots on excel? i know square To get replies by our experts at nominal charges, follow this link to buy points and [2] The lookup functions should have an optional argument for the return In addition to A1^(1/3) you can use =POWER(A1, 1/3). #2. Calculate SQUARE Root of a Number Using POWER Function Apart from the square root, we can use it to calculate cube root or any nth.