Check Sheet Logo
Check Sheet

IMCONJUGATE

The IMCONJUGATE formula returns the complex conjugate of a given complex number. This formula is commonly used in engineering and physics calculations involving complex numbers.

Usage

Use the IMCONJUGATE formula with the syntax shown below, it has 1 required parameter:

=IMCONJUGATE(number)
Parameters:
  1. number (required):
    The complex number for which you want to find the complex conjugate.

Examples

Here are a few example use cases that explain how to use the IMCONJUGATE formula in Google Sheets.

Finding the reflection coefficient of a transmission line

In electrical engineering, the reflection coefficient of a transmission line is an important parameter that describes how much of an electromagnetic wave is reflected by an impedance mismatch. The IMCONJUGATE formula can be used to calculate the reflection coefficient of a transmission line by finding the complex conjugate of the load impedance and using it in the reflection coefficient formula.

Calculating the impedance of a circuit

In electrical engineering, the impedance of a circuit is a measure of the opposition to current flow. The IMCONJUGATE formula can be used to calculate the impedance of a circuit by finding the complex conjugate of the admittance and using it in the impedance formula.

Solving differential equations with complex roots

In mathematics, differential equations with complex roots require complex conjugates to be found in order to solve the equation. The IMCONJUGATE formula can be used to find the complex conjugate of a given complex root.

Common Mistakes

IMCONJUGATE not working? Here are some common mistakes people make when using the IMCONJUGATE Google Sheets Formula:

Incorrect argument type

One of the most common mistakes is providing an argument that is not a complex number. The IMCONJUGATE function requires a complex number as its argument, which consists of a real and imaginary part separated by the +i symbol. If the argument is not a complex number, the function will return an error. To fix this, double-check your argument and make sure it is a complex number.

Missing argument

Another common mistake is omitting the argument. The IMCONJUGATE function requires one argument, which is the complex number you want to find the conjugate of. If you don't provide an argument, the function will return an error. To fix this, make sure you include the argument in your formula.

Incorrectly formatted argument

It's also possible to make mistakes when formatting the complex number argument. The IMCONJUGATE function requires the argument to be in the form of a+bi, where a is the real part and b is the imaginary part. Make sure you use the correct format and include the +i symbol between the real and imaginary parts.

Misspelling the function name

A common mistake is misspelling the function name as IMCONJUGATION instead of IMCONJUGATE. If you misspell the function name, Google Sheets won't recognize it as a valid function and will return an error. To fix this, make sure you spell the function name correctly.

Using the function outside of Engineering category

The IMCONJUGATE function is part of the Engineering category in Google Sheets. If you try to use the function outside of this category, Google Sheets won't recognize it as a valid function and will return an error. To fix this, make sure you use the function within the Engineering category.

The following functions are similar to IMCONJUGATE or are often used with it in a formula:

  • IMAGINARY

    The IMAGINARY function in Google Sheets returns the imaginary coefficient of a given complex number. The imaginary coefficient is the part of the complex number that is multiplied by the imaginary unit. This function is often used in engineering and scientific applications that involve complex numbers.

  • IMABS

    The IMABS function returns the absolute value (modulus) of a complex number. This is useful when working with complex numbers in engineering or scientific calculations.

  • IMREAL

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

  • IMSIN

    The IMSIN function returns the sine of a complex number. The function takes a single parameter, which is a complex number in the form of a+bi. The function returns the sine of the complex number. This function is commonly used in engineering and scientific applications for analyzing waves and oscillations.

Learn More

You can learn more about the IMCONJUGATE Google Sheets function on Google Support.