IMREAL function

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

Syntax

IMREAL(inumber)

Argument

Description

Remarks

inumber

A complex number for which you want the real coefficient.

  • If inumber is not in the form x + yi or x + yj, this function returns the #NUM! error value.

General remarks

Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1
2
AB
FormulaDescription (Result)
=IMREAL("6-9i")Real coefficient of 6-9i (6)
Rate this content:
Not helpfulSomewhat helpfulHelpfulVery helpfulSolved my problem 
 
Share your feedback about this topic