Spread Formula Reference
Formula Functions / Functions H to L / IMSUM
In This Topic
    IMSUM
    In This Topic

    This function returns the sum of two or more complex numbers in the x+yi or x+yj text format.

    Syntax

    IMSUM(complexnum1,complexnum2, ...)

    Arguments

    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.

    Remarks

    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.

    Data Types

    Accepts number and string data. Returns string data.

    Examples

    IMSUM("2+5j","5+3i")

    IMSUM(A1:B5)

    IMSUM({"2+5j","5+3i"})

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    COMPLEX | IMSUB | Engineering Functions | Complex Numbers in Engineering Functions