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
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,