You are here:

Geometry/Complex Number Data in Excel Application.


Dear Prof Azeem‎

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.


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,


All Answers

Answers by Expert:

Ask Experts


Azeem Hussain


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.

CALPHAD: Computer Coupling of Phase Diagrams and Thermochemistry

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

©2017 All rights reserved.

[an error occurred while processing this directive]