How to Use the IMCONJUGATE Function in Excel

Today, we’ll explore the IMCONJUGATE function, a highly useful tool in both Excel and Google Sheets.

Overview

The IMCONJUGATE function returns the complex conjugate of a specified complex number. Essentially, this function reverses the sign of the imaginary component of the complex number.

Syntax

The syntax for the IMCONJUGATE function is consistent across both Excel and Google Sheets:

=IMCONJUGATE(inumber)

• inumber: This required argument represents the complex number whose conjugate you need to find.

Examples

To better understand the IMCONJUGATE function, let’s review a couple of examples:

Example 1: Imaginary Number

Consider a complex number in cell A1: 3+4i. To determine its conjugate, you would use the formula:

=IMCONJUGATE(A1)

This formula returns 3-4i, the complex conjugate of the original number.

Example 2: Using Direct Input

You can also input the complex number directly into the formula. For instance:

=IMCONJUGATE(2-6i)

This will produce 2+6i, which is the conjugate of 2-6i.

Use Case

The IMCONJUGATE function is extremely valuable in various applications, such as electrical engineering calculations and signal processing, or any discipline that utilizes complex numbers.

Finding the conjugate of a complex number simplifies many mathematical operations, enhancing efficiency and clarity in calculations.

With a better understanding of the IMCONJUGATE function in Excel and Google Sheets, you’re now equipped to harness its capabilities in your projects and worksheets.

More information: https://support.microsoft.com/en-us/office/imconjugate-function-2e2fc1ea-f32b-4f9b-9de6-233853bafd42