# 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  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.