answersLogoWhite

0

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.

User Avatar

Wiki User

14y ago

Still curious? Ask our experts.

Chat with our AI personalities

RafaRafa
There's no fun in playing it safe. Why not try something a little unhinged?
Chat with Rafa
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
CoachCoach
Success isn't just about winning—it's about vision, patience, and playing the long game.
Chat with Coach

Add your answer:

Earn +20 pts
Q: How do you evaluate cube roots of complex numbers in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Math & Arithmetic

What is an expression in excel?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


How do you do standard deviation on Microsoft Excel?

Use the STDEV() function.


How do you make graphs charts and tables?

Use Microsoft Excel.


How do you create 3D chart in Microsoft Excel?

There are many charting options in Excel. When you choose your chart, select a 3D chart.


What are statistical packages of lotus and Excel used in research?

Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.