Forum Discussion
LouisDeconinck
Dec 22, 2023Brass Contributor
Complex numbers in Excel
Did you know that Excel can handle complex mathematical operations with complex numbers? Complex numbers, expressed as "a + bi," where 'a' and 'b' are real numbers and 'i' is the imaginary unit, can ...
TChrapkiewicz
Nov 13, 2026Copper Contributor
It is time that Excel is extended so that it accepts complex numbers as a native datatype.
The current method of treating them as text and having special functions is simply unacceptable today. Many modern languages have the complex data type.
That is if two cells have complex numbers, simply use the sum or other numeric functions.