Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the formula for cube root on Excel?
Any one know how i can do cube roots on excel? i know square root is IMSQRT,
but i do not know what cube root funtion is? |
#2
|
|||
|
|||
=A2^(1/3)
tbh_29 wrote: Any one know how i can do cube roots on excel? i know square root is IMSQRT, but i do not know what cube root funtion is? -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
#3
|
|||
|
|||
The function for square root is SQRT. The IMSQRT is for complex numbers.
In addition to A1^(1/3) you can use =POWER(A1, 1/3) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tbh_29" wrote in message ... Any one know how i can do cube roots on excel? i know square root is IMSQRT, but i do not know what cube root funtion is? |
#4
|
|||
|
|||
If working with Complex numbers...
=IMPOWER(A1,1/3) HTH. -- Dana DeLouis Win XP & Office 2003 "tbh_29" wrote in message ... Any one know how i can do cube roots on excel? i know square root is IMSQRT, but i do not know what cube root funtion is? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) |