You are here:

Geometry/Complex Number Data in Excel Application.

Advertisement


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

Awaiting your reply,

Thanks & Regards,
Prashant S Akerkar

Answer
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

Geometry

All Answers


Answers by Expert:


Ask Experts

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.

©2016 About.com. All rights reserved.