The `IMCONJUGATE` function in Excel is used to find the complex conjugate of a given complex number. The complex conjugate is a complex number with an equal real part and an imaginary part that is the negation of the imaginary part of the original complex number.
Here’s how you can use the `IMCONJUGATE` function:
Syntax
IMCONJUGATE(inumber)
- inumber: This is the complex number for which you want to find the conjugate. It can be a text representation of a complex number (e.g., “3+4i”), a cell reference containing a complex number, or an output from another function that returns a complex number.
Steps to Use IMCONJUGATE
=IMCONJUGATE("3+4i")
=IMCONJUGATE(A1)
- Enter The Complex Number: First, ensure that the complex number you want to find the conjugate of is either in a cell or typed directly into the formula. The complex number should be in the form `x+yi` or `x-yi`, where x and y are numbers.
- Formula Entry: Click on the cell where you want the result to appear.
- Enter the `IMCONJUGATE` Function:
- If you’re entering a complex number directly in the formula, type:
- If the complex number is in a cell, say A1, type:
- Press Enter: After typing in the formula, press Enter. The cell will display the complex conjugate of the given complex number.
Example
Suppose you have a complex number in cell A1 that is “5+7i”. To find its conjugate:
=IMCONJUGATE(A1)
- Click on another cell (e.g., B1) and enter the following formula:
This will display “5-7i” in cell B1.
Important Notes
- Ensure the complex number is correctly formatted as text or as an output from functions like `COMPLEX`.
- `IMCONJUGATE` is available in Excel 2007 and later versions.
This function is particularly useful in fields such as engineering and physics, where complex numbers frequently arise in calculations.
Unlock Your Potential
Excel
Access
Power BI
