How to Use the IMCONJUGATE Function in WPS on Windows

Last updated:July 20, 2026

Use IMCONJUGATE through 4 how-to topics, covering function entry, cell references, nested formulas, and error checking; choose a topic from the index and follow the steps to complete it.

How-to Index

No.TopicMembership Requirement
11. Enter the IMCONJUGATE functionFree
22. Reference a complex number from another cellFree
33. Combine IMCONJUGATE with other functionsFree
44. Check formula errors and recalculate resultsFree

How-to Guide

1. Enter the IMCONJUGATE function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the target cell.
  2. Type = to begin the formula.
  3. Type IMCONJUGATE(.
  4. Enter a complex number as text, such as "3+4i".
  5. Type the closing parenthesis and press Enter to view the result.

Success Criteria

  • On-screen result: The target cell shows the conjugate result, such as 3-4i.
  • Next action available: You can copy the formula or edit the argument further.

Tips While Using

  • Common mistake: If the complex-number text format is invalid, the formula may return an error.
  • Environment note: The formula must begin with =.

2. Reference a complex number from another cell

Entry point: Worksheet cell → formula bar

  1. Enter a complex number in one cell first, for example 3+4i in A1.
  2. Select the result cell.
  3. Type the formula =IMCONJUGATE(A1).
  4. Press Enter to view the result.
  5. If needed, fill the formula down to process more rows.

Success Criteria

  • On-screen result: The result cell shows the conjugate of the referenced value.
  • Next action available: When A1 changes, the result updates accordingly.

Tips While Using

  • Common mistake: If the referenced cell does not contain valid complex-number text, the function may not return the expected result.

3. Combine IMCONJUGATE with other functions

Entry point: Formulas tab → formula bar

  1. Select the cell where you want the result to appear.
  2. Enter a combined formula that includes IMCONJUGATE.
  3. Reference other cells or function results as needed.
  4. Check that parentheses and separators are complete.
  5. Press Enter to confirm the formula.

Success Criteria

  • On-screen result: The cell returns the result of the combined formula.
  • Next action available: You can continue editing the nested structure in the formula bar.

Tips While Using

  • Common mistake: Mismatched parentheses in nested formulas can cause errors.
  • Environment note: For longer formulas, editing in the formula bar makes the structure easier to review.

4. Check formula errors and recalculate results

Entry point: Result cell → formula bar

  1. Select the cell that shows an error or an unexpected result.
  2. Check that the function name is spelled IMCONJUGATE.
  3. Check the number of arguments, parentheses, and complex-number text format.
  4. If other cells are referenced, confirm that the referenced content is valid.
  5. After making changes, press Enter to recalculate the result.

Success Criteria

  • On-screen result: The error disappears or the result returns to normal.
  • Next action available: You can copy or reuse the corrected formula.

Tips While Using

  • Common mistake: Entering plain text as a complex-number argument can affect the result.
  • Environment note: If worksheet calculation behavior changes, confirm the formula result again manually.