Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cubed square root Damon Longworth Excel Worksheet Functions 8 February 13th 07 01:38 PM
Can you find the cubed root on excel Me Excel Worksheet Functions 2 January 15th 07 02:00 AM
what is formula for cubed root JcR Excel Worksheet Functions 2 May 22nd 06 08:06 AM
what is the formula for the cubed root of JcR Excel Discussion (Misc queries) 1 May 22nd 06 01:08 AM
Does excel have a 'cubed root' function? How can it work it out? Di in Oz Excel Worksheet Functions 1 April 30th 05 12:37 AM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"