IMAGINARY function

The IMAGINARY function in Excel is used to return the imaginary coefficient of a complex number. The imaginary part of a complex number is the value that is multiplied by the imaginary unit i (or j in Excel).

Syntax

IMAGINARY(inumber)

Parameters

• inumber: This is the complex number (in the form of a string) for which you want to extract the imaginary part. The complex number should be entered in the form a + bi or a + bj, where a is the real part and b is the imaginary part. Excel recognizes both i and j as the imaginary unit.

How It Works

The IMAGINARY function extracts the coefficient of the imaginary part from a complex number. The complex number is typically represented as a + bi or a + bj, where a is the real part, and b is the imaginary part.

For example, in the complex number 3 + 4i, the real part is 3, and the imaginary part is 4. The IMAGINARY function will return 4 as the imaginary coefficient.

Examples

1. Basic Example: To extract the imaginary part of the complex number 3 + 4i:

   =IMAGINARY("3+4i")
   

   The result will be 4, as 4i is the imaginary part.

2. Complex Number with Negative Imaginary Part: To extract the imaginary part of the complex number 5 - 12i:

   =IMAGINARY("5-12i")
   

   The result will be -12, as -12i is the imaginary part.

3. Complex Number with Decimal Parts: To extract the imaginary part of the complex number 2.5 + 3.5i:

   =IMAGINARY("2.5+3.5i")
   

   The result will be 3.5, as 3.5i is the imaginary part.

4. Complex Number with No Imaginary Part: To extract the imaginary part of the complex number 7 (purely real number):

   =IMAGINARY("7")
   

   The result will be 0, since there is no imaginary part.

5. Using Cell Reference: If cell A1 contains the complex number "7+24i", you can extract its imaginary part:

   =IMAGINARY(A1)
   

   The result will be 24, as 24i is the imaginary part.

Important Notes

• If the complex number is purely real (i.e., there is no imaginary part), the IMAGINARY function will return 0.
• The IMAGINARY function works only with complex numbers in the format a + bi or a + bj. If the input is not a valid complex number, Excel will return a #VALUE! error.
• The imaginary part can be a positive or negative number, depending on the sign of the imaginary coefficient in the complex number.

Summary

The IMAGINARY function in Excel is used to extract the imaginary part (coefficient of i or j) from a complex number. It is useful in various mathematical, engineering, and scientific calculations that involve complex numbers, where you may need to isolate and work with the imaginary part separately.