SpreadJS Documentation
IMREAL
SpreadJS Documentation > Formula Reference > Formula Functions > IMREAL

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.

Data Types

Accepts number and string data. Returns number data.

Examples

IMREAL("2-5j")

See Also