You are here:

# Geometry/Complex Number Data in Excel Application.

Question
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

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.

Azeem
Questioner's Rating
 Rating(1-10) Knowledgeability = 10 Clarity of Response = 10 Politeness = 10 Comment Dear Prof Azeem Thank you. Thanks & Regards, Prashant S Akerkar

• Ask a Question

Geometry

Volunteer

#### Azeem Hussain

##### Expertise

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

##### Experience

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.