Use the IMDIV function in WPS with 3 how-to topics, all available without membership, and jump from the index to the matching steps below.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Enter IMDIV from the Insert Function dialog | Free |
| 2 | 2. Type the formula directly in a cell | Free |
| 3 | 3. Review syntax and parameter details | Free |
How-to Guide
1. Enter IMDIV from the Insert Function dialog
Entry point: Formula tab → Insert Function
- Select the cell where you want to enter the formula.
- Click the
fxbutton in the formula bar, or click Insert Function on the Formula tab. - Search for
IMDIVin the dialog box. - Select the function and click OK.
- Enter the required parameters in the Function Arguments dialog.
- Click OK to insert the function.
Success Criteria
- The selected cell now contains the IMDIV function.
- After the parameters are entered, the cell returns a calculation result.
- You can continue editing, copying, or filling the formula.
Tips While Using
- Enter complex-number arguments in the required format.
- Use English punctuation for parameter separators.
- If the result looks incorrect, check the parameter order and content again.
2. Type the formula directly in a cell
Entry point: worksheet cell or formula bar
- Select the target cell.
- Type
=IMDIV(...)directly in the cell or formula bar. - Press Enter to confirm.
- If needed, enter the function name and parentheses first, then complete the parameters.
Success Criteria
- The IMDIV formula has been entered in the cell.
- Pressing Enter returns a result or keeps the formula ready for editing.
- The formula can still be edited in the formula bar.
Tips While Using
- A Chinese comma can prevent the formula from calculating as expected, so use an English comma.
- If you reference other cells, make sure the references point to the correct values.
- If the result is different from what you expect, check whether the referenced content is in a valid complex-number format.
3. Review syntax and parameter details
Entry point: Formula tab → Insert Function
- Click Insert Function on the Formula tab.
- Search for
IMDIV. - Select the function to review its syntax and parameter details.
- If needed, open the related help information to confirm how to use it.
Success Criteria
- You can see the IMDIV function name and syntax information.
- You can confirm how the parameters should be entered.
- You can return to the worksheet and continue entering or editing the formula.
Tips While Using
- Syntax details are useful for checking parameter count and order before entry.
- If this is your first time using a complex-number function, review the description before entering the formula.