ExcelBanter - how to find cubed root of a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to find cubed root of a number (https://www.excelbanter.com/excel-worksheet-functions/230562-how-find-cubed-root-number.html)

westvette

how to find cubed root of a number

I want to calculate the radius of a sphere knowing its volume.

volume = 4/3Pi r3
r3 = volume/ 4/3Pi
r= cubed root of r3

How do I find this cubed root.

Jacob Skaria

how to find cubed root of a number

With value in A1 the below formula will give you the cube root
=A1^(1/3)

If this post helps click Yes
---------------
Jacob Skaria

"westvette" wrote:

I want to calculate the radius of a sphere knowing its volume.

volume = 4/3Pi r3
r3 = volume/ 4/3Pi
r= cubed root of r3

How do I find this cubed root.

Jacob Skaria

how to find cubed root of a number

OR

=POWER(A1,1/3)

If this post helps click Yes
---------------
Jacob Skaria

"westvette" wrote:

I want to calculate the radius of a sphere knowing its volume.

volume = 4/3Pi r3
r3 = volume/ 4/3Pi
r= cubed root of r3

How do I find this cubed root.

All times are GMT +1. The time now is 10:15 AM.