Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / IMAGINARY
In This Topic
    IMAGINARY
    In This Topic

    This function returns the imaginary coefficient of a complex number.

    Syntax

    IMAGINARY(complexnum)

    Arguments

    The complexnum argument is a complex number for which to return the imaginary coefficient.

    Remarks

    An error is returned if the complexnum argument is not in the form "x+yi" or "x+yj". For more information, refer to Complex Numbers in Engineering Functions.

    Data Types

    Accepts number and string data. Returns number data.

    Examples

    IMAGINARY("3+5j")

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    COMPLEX | IMREAL | Engineering Functions | Complex Numbers in Engineering Functions