Formula Functions > Functions H to L > IMSUM |
This function returns the sum of two or more complex numbers in the x+yi or x+yj text format.
IMSUM(complexnum1,complexnum2, ...)
The arguments are the complex numbers to multiply. There can be up to 29 of them.
Arrays in the "x+yi" or "x+yj" format or range references are allowed.
An error is returned if the arguments are not in the form "x+yi" or "x+yj". For more information, refer to Complex Numbers in Engineering Functions.
Accepts number and string data. Returns string data.
IMSUM("2+5j","5+3i")
IMSUM(A1:B5)
IMSUM({"2+5j","5+3i"})
This function is available in product version 2.0 or later.
COMPLEX | IMSUB | Engineering Functions | Complex Numbers in Engineering Functions