Formulas > =IMCONJUGATE()

How To Use IMCONJUGATE() Function in Google Sheets


Returns the complex conjugate of a number.

Common questions about the IMCONJUGATE formula:
-What does the IMCONJUGATE formula do?
-When should the IMCONJUGATE formula be used?
-How is the IMCONJUGATE formula different from other formulas?

How can the IMCONJUGATE formula be used appropriately?
-The IMCONJUGATE function can be used to convert Imaginary Numbers into their Real-Number equivalent parts (the Real and Imaginary Parts). It can also be used to convert Real-Number values into Imaginary-Number values.

How can the IMCONJUGATE formula be commonly mistyped?
-The IMCONJUGATE formula can be easily mistyped as “IMCONGE” or “IMCONJUGT” due to similar sounding words.

What are some common ways the IMCONJUGATE formula is used inappropriately?
-The IMCONJUGATE formula should not be used to solely convert between Imaginary Numbers and Real-Number values. When converting between these two data types, it is important to use other formulas as well, such as the SQRT(), ABS(), and LOG().

What are some common pitfalls when using the IMCONJUGATE formula?
-It is important to know that when converting between complex numbers and real numbers, the sign of the imaginary part should be changed when using the IMCONJUGATE formula.

What are common mistakes when using the IMCONJUGATE formula?
-Typing the wrong formula name is one of the most common mistakes when using the IMCONJUGATE formula. Be sure to double-check that you are using the correct formula. Additionally, when converting between complex and real numbers, it is important to remember to take into account the sign change of the imaginary part.

What are common misconceptions people might have with the IMCONJUGATE formula?
-One common misconception that people might have with the IMCONJUGATE formula is that it can be used to convert between any two numbers. In fact, the IMCONJUGATE formula should only be used to convert between imaginary numbers and real numbers.

How To Actually Use IMCONJUGATE() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the IMCONJUGATE() formula:

54 engineering formulas in excel 2016

This video is about how to create 54 Engineering Functions with Examples in MS Excel Spreadsheet 2016.

Generate a IMCONJUGATE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.