converts real and imaginary to complex · from excel · excel: not yet compared · sheets: not yet compared

signature

COMPLEX(real_num, i_num, [suffix])

returns: text (complex number)

argument	required
real_num	required
i_num	required
suffix	optional · defaults to 0

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• BESSELI returns modified Bessel function In(x)
• BESSELJ returns Bessel function Jn(x)
• BESSELK returns modified Bessel function Kn(x)
• BESSELY returns Bessel function Yn(x)
• BIN2DEC converts binary number to decimal
• BIN2HEX converts binary number to hexadecimal