Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
  - HARMEAN
  - HBARSPARKLINE
  - HEX2BIN
  - HEX2DEC
  - HEX2OCT
  - HISTOGRAMSPARKLINE
  - HLOOKUP
  - HOUR
  - HSTACK
  - HYPERLINK
  - HYPGEOM.DIST
  - HYPGEOMDIST
  - IF
  - IFERROR
  - IFNA
  - IFS
  - IMABS
  - IMAGE
  - IMAGINARY
  - IMARGUMENT
  - IMCONJUGATE
  - IMCOS
  - IMCOSH
  - IMCOT
  - IMCSC
  - IMCSCH
  - IMDIV
  - IMEXP
  - IMLN
  - IMLOG10
  - IMLOG2
  - IMPOWER
  - IMPRODUCT
  - IMREAL
  - IMSEC
  - IMSECH
  - IMSIN
  - IMSINH
  - IMSQRT
  - IMSUB
  - IMSUM
  - IMTAN
  - INDEX
  - INDIRECT
  - INFO
  - INT
  - INTERCEPT
  - INTRATE
  - IPMT
  - IRR
  - ISBLANK
  - ISERR
  - ISERROR
  - ISEVEN
  - ISFORMULA
  - ISLOGICAL
  - ISNA
  - ISNONTEXT
  - ISNUMBER
  - ISO.CEILING
  - ISODD
  - ISOMITTED
  - ISOWEEKNUM
  - ISPMT
  - ISREF
  - ISTEXT
  - JIS
  - KURT
  - LAMBDA
  - LARGE
  - LCM
  - LEFT
  - LEFTB
  - LEN
  - LENB
  - LET
  - LINEST
  - LINESPARKLINE
  - LN
  - LOG
  - LOG10
  - LOGEST
  - LOGINV
  - LOGNORM.DIST
  - LOGNORM.INV
  - LOGNORMDIST
  - LOOKUP
  - LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z

IMSUM

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.