WPS Features
Resources
Free AI Tools
Docs Center

How to Use the PERCENTOF Function in WPS on Windows

Last updated:July 13, 2026

This guide includes 3 how-to topics, all available without membership; use the How-to Index below to insert the function, type it directly, and check syntax details.

How-to Index

#TopicMembership
11. Insert PERCENTOF through the Insert Function dialog boxFree
22. Type a PERCENTOF formula directly in a cellFree
33. View PERCENTOF syntax and parameter detailsFree

How-to Guide

1. Insert PERCENTOF through the Insert Function dialog box

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

  1. Open WPS Sheets and 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 PERCENTOF in the Insert Function dialog box.
  4. Select the function and click OK.
  5. In the Function Arguments dialog box, enter the required parameters in order.
  6. Click OK to insert the function.

Success Criteria

  • UI state: The Function Arguments dialog box appears, or the formula is inserted into the target cell.
  • Next actions: You can continue editing parameters, confirm the result, or copy the formula to other cells.

Tips While Using

  • Common mistakes: Search with the English function name to avoid mismatched results.
  • Environment limits: If the current cell is read-only, switch to an editable worksheet first.

2. Type a PERCENTOF formula directly in a cell

Entry point: The target cell or the formula bar

  1. Open the worksheet and select the cell where you want to enter the formula.
  2. Type =PERCENTOF(...) directly in the cell or in the formula bar.
  3. Complete the required parameters.
  4. Press Enter to confirm.
  5. If you want to learn how to use the PERCENTOF function in WPS with syntax hints, type =PERCENTOF( and review the on-screen prompt information.

Success Criteria

  • UI state: The target cell shows the formula result, and the formula bar keeps the full formula.
  • Next actions: You can fill down, copy the formula, or return to the formula bar to revise parameters.

Tips While Using

  • Common mistakes: The formula must start with an equals sign, and the function name should use standard parentheses and parameter separators.
  • Environment limits: If the formula does not calculate as expected, check the cell format and parameter values.

3. View PERCENTOF syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter PERCENTOF in the search box.
  3. Select the function and review the syntax area in the dialog box.
  4. Click the help link for the function to open more detailed guidance.

Success Criteria

  • UI state: The syntax area shows information related to PERCENTOF(...).
  • Next actions: You can return to the worksheet to continue formula entry or adjust parameters after reviewing the help content.

Tips While Using

  • Common mistakes: If the wrong function is selected, the syntax panel will show a different function.
  • Environment limits: Opening the help link requires an internet connection.