deepcalc
DocsCOMPLEX

COMPLEX

View as markdown/docs/functions/complex.md Ask Claude about this pageOpens Claude with this page's address

Converts real and imaginary to complex.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Text (complex number)

Examples

=COMPLEX(3, 4)
Result 3+4i

Syntax

COMPLEX(real_num, i_num, [suffix])
real_num
number required
i_num
number required
suffix
text optional defaults to 0
BESSELIReturns modified Bessel function In(x). BESSELJReturns Bessel function Jn(x). BESSELKReturns modified Bessel function Kn(x). BESSELYReturns Bessel function Yn(x). BIN2DECConverts binary number to decimal. BIN2HEXConverts binary number to hexadecimal.