You are here:

- Home
- Science
- Math for Kids
- Geometry
- Complex Number Data in Excel Application.

Advertisement

Dear Prof Azeem

http://en.wikipedia.org/wiki/Microsoft_Excel

http://office.microsoft.com/en-us/excel/

http://en.wikipedia.org/wiki/Complex_number

A complex number is a number that can be expressed in the form a + bi, where a and b are real numbers and i is the imaginary unit, where i2 = −1.

Examples

---------

6720000000 + 4i

1991230000000 + 6i

18.7 + 2i

6720000000 + 1991230000000i

0.0000000000345 - 0.34562222222222i

1. Do the current excel version allows us to enter complex number data in cells ?.

Data supported are : Number,Currency, Date, Time, Percentage, Fraction, Scientific,Text, Special,Custom

2. Can it be useful to enter Complex Number Data in Excel Spreadsheet ?.

3. Functions, Formulas in Excel can then be used for adding, subtracting,multiplication,division,power etc

of complex numbers ?.

Examples : SUM(), POWER(),PRODUCT() etc

Awaiting your reply,

Thanks & Regards,

Prashant S Akerkar

Hi Prashant,

A number of the form a+bi can be entered in Excel as COMPLEX(a,b). There are special functions for operations on imaginary numbers, such as IMSUM, IMSUB, IMPROD, IMDIV, IMEXP. (Search for a function and type "imaginary" to see many others.) Depending on the version of Excel, these may be in an add-on. Consult the Microsoft Excel Help for further information.

Thanks for asking,

Azeem

- Add to this Answer
- Ask a Question

Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |

Comment | Dear Prof Azeem Thank you. Thanks & Regards, Prashant S Akerkar |

I welcome your questions on algebra, 2D and 3D geometry, parabolic functions and conic sections, and any other mathematical queries you may have.

4 years as a drop-in and by-appointment tutor at Champlain College.
Private tutor for dozens of clients over the past 8 years.**Publications**

CALPHAD: Computer Coupling of Phase Diagrams and Thermochemistry**Education/Credentials**

Bachelor of Science, Major Mathematics and Major Economics, McGill University, 2014.
Diploma of Collegiate Studies; Pure and Applied Science, Champlain College Saint-Lambert, 2010.