AI Assistant
Help Center AI Assistant is now available
Got questions about Lark? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now

IMCONJUGATE function for Sheets

1 min read
I. Intro
The IMCONJUGATE function returns the complex conjugate of a complex number.
The complex conjugate (also known as a conjugate) is formed by changing the sign of the imaginary part of a complex number.
II. About the function
  • Formula: =IMCONJUGATE(value)
  • Parameters:
  • value (required): The complex number to conjugate.
  • Example: =IMCONJUGATE("4+9i") results in "4-9i"
III. Steps
Use the IMCONJUGATE function
  1. Select a cell and click Formulas on the toolbar, then select Engineering > IMCONJUGATE. You can also directly enter =IMCONJUGATE in a cell.
  1. Enter the parameters in the cell. For example: =IMCONJUGATE(A2).
  1. Press Enter to display the result, which is 3 - 2i in this example.
  1. Drag the + icon in the lower-right corner of the cell to apply the formula to other cells.
250px|700px|reset
Delete the IMCONJUGATE function
Select the cell with the IMCONJUGATE function, and press Delete.
Written by: Lark Help Center
Updated on 2022-10-08
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom