Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a simple worksheet method to determine a cube root? I can find a
square root using X^.5. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
X^(1/3)
-- Regards, Dave "Bob Wall" wrote: Is there a simple worksheet method to determine a cube root? I can find a square root using X^.5. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try this:
For a value in A1 B1: =A1^(1/3) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Bob Wall" wrote: Is there a simple worksheet method to determine a cube root? I can find a square root using X^.5. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try using the POWER function Bob. Let's say that you want to find the cube
root of x, then =POWER(x,1/3) would work. In any case, to find the nth root of x, the generalization is =POWER(x,1/n) or like the others suggested =x^1/n, with n being non-zero. "Bob Wall" wrote: Is there a simple worksheet method to determine a cube root? I can find a square root using X^.5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
why can't excel do a simple find and copy row from a worksheet to. | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |