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

    This function returns the real coefficient of a complex number in the x+yi or x+yj text format.

    Syntax

    IMREAL(complexnum)

    Arguments

    The complexnum argument is a complex number for which to return the real 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

    IMREAL("2-5j")

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    COMPLEX | IMAGINARY | Engineering Functions | Complex Numbers in Engineering Functions