WPS Features
Resources
Free AI Tools
Docs Center

How to Use the DISC Function in WPS on Windows

Last updated:July 13, 2026

Use DISC with 3 how-to topics, including inserting the function, typing the formula directly, and reviewing syntax and arguments; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Insert DISC from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review the syntax and argument detailsFree

How-to Guide

1. Insert DISC from the Insert Function dialog box

Entry point: Formula tab → Insert Function, or the fx button in the formula bar

  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 Formula tab.
  3. Search for DISC in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each argument in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • On-screen result: The target cell shows the DISC result.
  • What you can do next: You can continue editing arguments, copy the formula, or save the workbook.

Tips While Using

  • Common mistake: Enter the standard function name DISC when searching.
  • Environment note: Make sure the worksheet is editable.

2. Type the formula directly in a cell

Entry point: Worksheet cell or formula bar

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

Success Criteria

  • On-screen result: The cell shows the calculated result, and the formula bar keeps the full formula.
  • What you can do next: You can fill, copy and paste, or adjust references.

Tips While Using

  • Common mistake: Use English commas as argument separators.
  • Environment note: Incorrect date or number formats in the arguments can cause an error.

3. Review the syntax and argument details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter DISC in the search box.
  3. Select the function and review the syntax: DISC(settlement, maturity, pr, redemption, [basis]).
  4. Click the help link for more details.

Success Criteria

  • On-screen result: You can see the DISC syntax structure and argument names.
  • What you can do next: You can return to the worksheet and continue entering the formula.

Tips While Using

  • Common mistake: Do not treat the optional basis argument as required.
  • Environment note: Opening a help page requires internet access.