Answers.com > Wiki Answers > Categories > Jobs & Education > Education > School Subjects > Math and Arithmetic > Numbers > Complex Numbers > How do you evaluate cube roots of complex numbers in Microsoft excel?

How do you evaluate cube roots of complex numbers in Microsoft excel?

In: Complex Numbers [Edit categories]

Answer:

Excel and also OpenOffice Calc have functions to do certain operations on complex numbers. The IMPOWER() function will handle what you want to do. Example: type the following in a cell =IMPOWER("-415+234i",1/3) and the result will be 5 + 6i. If you are using OpenOffice, then a semicolon is used rather than a comma in functions {=IMPOWER("-415+234i";1/3)}
The complex number is formatted as text. There are other functions: IMABS, IMARGUMENT, IMPRODUCT, etc. You can do a help search for Complex Numbers, or one of these functions that I mentioned.

First answer by ScottDave. Last edit by ScottDave. Contributor trust: 122 [recommend contributor ]. Question popularity: 1 [recommend question].

[report abuse]

Can you answer these Complex Numbers questions?

	Can you evaluate all integration in complex plane?	Answer it!
	What are imaginary and complex numbers?	Answer it!
	Why was complex numbers discovered?	Answer it!
	What is the current total number of parking spaces at the sports complex?	Answer it!
	What is the icon dance complex phone number?	Answer it!

Relevant answers:

Do negative numbers have cube roots cube roots?
Yes.
What are the roots of complex numbers in mathematics?
See the answer to the related question: 'How do you solve the power of an imaginary number?' (Link below)
What is the cube root of the number 8?
The cube root of the number 8 is 2(two).Cube Root-a number when multiplied 3 times equals a given number.
How do you work out the cube root of a number?
Try calculating the cube of different numbers, until you get close enough.
What is the cube root of a number?
The cube root of a number, is kind of like the square root, except 3 instead of 2. What number times itself three times equals that number? For example, 2 is the cube root of 8 because 2x2x2=8