| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cube root?
How can I calculate the cube root of a number? Is there a formula for this?
Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cube root?
Scott,
you use the math rule that the nth root of a number is the number raised to the 1/n. Thus for the cubic root: =A1^(1/3) From my teaching experience: don;t forget the parentheses. The exponentiation operator takes precedence over the division op. HTH Kostis Vezerides |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cube root?
Scott -
For example, with a number in cell A1, in some other cell enter =A1^(1/3) - Mike www.mikemiddleton.com "Scott" wrote in message ... How can I calculate the cube root of a number? Is there a formula for this? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cube root?
To find the nth root of a number, raise that number to the power of 1/n. For
example, to find the cube root of 8 in a cell, type the following: =8^(1/3) from http://support.microsoft.com/Default.aspx?kbid=271143 -- Greetings from New Zealand Bill K "Scott" wrote in message ... How can I calculate the cube root of a number? Is there a formula for this? Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cube root?
Oh yeah - I remember now! Thanks much for your help!
"vezerid" wrote: Scott, you use the math rule that the nth root of a number is the number raised to the 1/n. Thus for the cubic root: =A1^(1/3) From my teaching experience: don;t forget the parentheses. The exponentiation operator takes precedence over the division op. HTH Kostis Vezerides |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cube root?
And, if you prefer: =POWER(A1, 1/3)
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Scott" wrote in message ... How can I calculate the cube root of a number? Is there a formula for this? Thanks! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cube root?
"Scott" wrote in message ... How can I calculate the cube root of a number? Is there a formula for this? Thanks! Only way I've managed to do it is value^0.33333333333333 Which is pretty good... Charlie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate a cube root | New Users to Excel | |||
| cube root | Excel Worksheet Functions | |||
| What is the formula for cube root on Excel? | Excel Worksheet Functions | |||
| I need the syntax for the cube root function in excel. | Excel Discussion (Misc queries) | |||
| Cube Root | Excel Discussion (Misc queries) | |||
Linear Mode
