WPS Features
Resources
Free AI Tools
Docs Center

How to Use the IMSUB Function in WPS on Windows

Last updated:July 13, 2026

Use IMSUB in WPS with 3 how-to topics, all available without membership; choose a topic from the index and follow the steps to complete the task.

How-to Index

No.TopicAccess
11. Insert IMSUB from the Insert Function dialogFree
22. Type the IMSUB formula directly in a cellFree
33. Check IMSUB syntax and parameter detailsFree

How-to Guide

1. Insert IMSUB from the Insert Function dialog

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for IMSUB in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameters in the Function Arguments dialog.
  6. Click OK to insert the function.

Success Criteria

  • The selected cell now contains an IMSUB formula.
  • The parameter positions are visible and can still be edited if needed.

Tips While Using

  • Make sure the parameters use a valid complex-number format.
  • Keep the parameter format consistent so the result can be calculated correctly.

2. Type the IMSUB formula directly in a cell

Entry point: Worksheet cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =IMSUB(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review the function details, type =IMSUB( and press F1 to open syntax help.

Success Criteria

  • The cell shows a result or remains ready for you to complete the parameters.
  • The formula bar lets you continue editing the IMSUB formula.

Tips While Using

  • The formula must start with an equals sign.
  • Use standard English punctuation for separators so the formula can be recognized correctly.

3. Check IMSUB syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type IMSUB in the search box.
  3. Select the function to review the syntax IMSUB(...).
  4. Click the help link for the function to open more details.

Success Criteria

  • You can see the IMSUB function name and syntax structure.
  • You can continue entering parameters or return to the worksheet to finish the formula.

Tips While Using

  • Confirm the parameter order before entering the final formula.
  • If you need more detail, review the help information and compare it with your worksheet input.