SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / COMPLEX
In This Topic
    COMPLEX
    In This Topic

    This function converts real and imaginary coefficients into a complex number.

    Syntax

    COMPLEX(realcoeff,imagcoeff,suffix)

    Arguments

    This function has these arguments:

    Argument Description
    realcoeff Coefficient of the real part of the complex number
    imagcoeff Coefficient of the imaginary part of the complex number
    suffix (Optional) Suffix of the imaginary part of the complex number, may be either "i "or "j". If omitted, "i" is used.

    Remarks

    For the suffix, use lowercase for "i" and "j" to prevent errors.

    An error is returned if the real or imaginary coefficients are non-numeric.

    Data Types

    Accepts number and string data. Returns string data.

    Examples

    COMPLEX(3,5)

    COMPLEX(3,5,"j")

    See Also