G Guest Jul 4, 2005 #1 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?
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?
A Aladin Akyurek Jul 4, 2005 #2 =A2^(1/3) tbh_29 said: 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? Click to expand... -- [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.
=A2^(1/3) tbh_29 said: 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? Click to expand... -- [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.
B Bernard Liengme Jul 5, 2005 #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
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
