How to do a Cube Root in Excel?

How to do a Cube Root in Excel?
Last Updated on 29/09/2023
Reading time: 2 minutes

There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.

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:

Cube Root of 64

How to 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 SQuare RooT) 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.

Scientist calculator of Windows 8
Calculator for Windows 8

Even if the function doesn't exist, it is not possible 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

SQRT function

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

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

Square root with POWER

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

=POWER(125,1/3) = 5

Calculation of a cube root in Excel

Leave a Reply

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

How to do a Cube Root in Excel?

Reading time: 2 minutes
Last Updated on 29/09/2023

There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.

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:

Cube Root of 64

How to 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 SQuare RooT) 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.

Scientist calculator of Windows 8
Calculator for Windows 8

Even if the function doesn't exist, it is not possible 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

SQRT function

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

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

Square root with POWER

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

=POWER(125,1/3) = 5

Calculation of a cube root in Excel

Leave a Reply

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