How to do a Cube Root in Excel?

How to do a Cube Root in Excel?
Last Updated on 04/05/2024
Reading time: 2 minutes

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

  1. The SQRT function

    The SQRT function return the SQuare RooT of a number

  2. 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:

Cube Root of 64

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

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 04/05/2024

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

  1. The SQRT function

    The SQRT function return the SQuare RooT of a number

  2. 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:

Cube Root of 64

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

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 *