**There is no cube root function in Excel. However, a solution exists to perform a cube root calculation with another Excel function.**

**The SQRT function**The SQRT function return the SQuare RooT of a number

**The POWER function**To find a cube root, you need to use the POWER function and manipulate the power argument.

## What is a cube root?

Let's say you multiply 3 times the same number. For example,

=4*4*4 => 64

Or you can also use the POWER function

=POWER(4,3) => 64

So, **the cube root of 64** is 4

And the writing of this formula is:

## How do you make a cube root in Excel?

Despite more than 500 functions, **there is no cube root function in Excel **😲😱😡 There is the **SQRT function** (for **SQ**uare **R**oo**T**) which returns the square root of a number. But no Cube Root function or nth root for that matter.

Also, before Windows 10, the scientific calculator of Windows has this option. Since then, **this option has been removed from the scientific calculator**.

Even if the function doesn't exist, it is impossible to do the calculation 😉 For that, we will use the **POWER function**. Let's start with a simple square root calculation. A square root is also the fact of raising a number to the power of 1/**2**

=ROOT(81) => 9

So in the case of a square root, we might as well write

=POWER(81,1/2) => 9

So to make a cube root, you must apply a power **of 1/3** to your number.

=POWER(125,1/3) = 5