Class Complex

  • All Implemented Interfaces:
    FreeRefFunction, Function, Function2Arg, Function3Arg

    public class Complex
    extends Object
    implements FreeRefFunction
    Implementation for Excel COMPLEX () function.

    Syntax:
    COMPLEX (real_num,i_num,suffix )

    Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

    All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! error value. All functions that accept two or more complex numbers require that all suffixes match.

    real_num The real coefficient of the complex number. If this argument is nonnumeric, this function returns the #VALUE! error value.

    i_num The imaginary coefficient of the complex number. If this argument is nonnumeric, this function returns the #VALUE! error value.

    suffix The suffix for the imaginary component of the complex number.

    • If omitted, suffix is assumed to be "i".
    • If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value.