Basic Description

The Excel IMCONJUGATE function returns the complex conjugate of a supplied complex number.

Syntax: IMCONJUGATE( inumber )

where the inumber argument is a complex number.


Excel Imconjugate Function Examples

The spreadsheet below shows examples of the Excel Imconjugate function, used find the complex conjugate of several complex numbers. The spreadsheet on the left shows the formulas and the spreadsheet on the right shows the results.

1 =IMARGUMENT( “5+2i” )
2 =IMARGUMENT( “2-i” )
4 =IMARGUMENT( “3i” )
5 =IMARGUMENT( “4+i” )
1 5-2i
2 2+i
3 6
4 -3i
5 4-i



Imconjugate Function Errors

If you get an error from the Excel Imconjugate Function, this is likely to be one of the following:

#NUM! Occurs if the supplied inumber argument is not recognised as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled in your Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment