Spread.NET 18 Formula Reference
Formula Functions / Functions A to C / 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.

    For more information, refer to Complex Numbers in Engineering Functions.

    Data Types

    Accepts number and string data. Returns string data.

    Examples

    COMPLEX(3,5)

    COMPLEX(3,5,"j")

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    IMAGINARY | IMREAL | Engineering Functions | Complex Numbers in Engineering Functions