How to Use the IMSUB Function in WPS on Windows

Last updated:July 17, 2026

Use IMSUB through 3 how-to topics, all available without membership; choose a topic from the How-to Index and follow the steps to complete it.

How-to Index

No.TopicMembership Requirement
11. Enter the IMSUB functionFree
22. Fill in the arguments with syntax promptsFree
33. Check the result and recalculate if neededFree

How-to Guide

1. Enter the IMSUB function

Entry point: Formula tab → formula bar

  1. Open Spreadsheet and select the cell where you want the result to appear.
  2. Type = in the cell or in the formula bar.
  3. Continue by typing IMSUB( to start the function.

Success Criteria

  • Interface result: =IMSUB( appears in the formula bar.
  • Next action available: You can continue entering the two arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with an equals sign, the content may be treated as plain text.
  • Environment note: You need to be in an editable spreadsheet cell.

2. Fill in the arguments with syntax prompts

Entry point: function input state in the formula bar

  1. After IMSUB(, enter the first complex number or a cell reference.
  2. Enter the separator, then add the second complex number or cell reference.
  3. Check the syntax prompt for argument type, count, and format.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell displays a calculation result.
  • Next action available: You can select the result cell and review the full formula in the formula bar.

Tips While Using

  • Common mistake: Unclosed parentheses or a missing separator between arguments can cause a formula error.
  • Environment note: The complex-number format needs to match the function requirements.

3. Check the result and recalculate if needed

Entry point: result cell and keyboard shortcut

  1. Check whether the result cell returns the expected complex-number difference.
  2. If the formula references other cells, confirm that the source values use the correct format.
  3. If the result does not refresh in time, press F9 to recalculate manually.
  4. If the issue remains, return to the formula bar and check for circular references or numbers stored as text.

Success Criteria

  • Interface result: The result cell shows the expected complex-number result.
  • Next action available: When you change the inputs, the result updates accordingly.

Tips While Using

  • Common mistake: Numbers stored as text can affect the calculation result.
  • Environment note: In complex worksheets, circular references should be checked first.