How to Use the PERCENTOF Function in WPS on Windows

Last updated:July 20, 2026

This section includes 4 how-to topics for the PERCENTOF function, and all 4 are available without membership; use the index below to jump to the task you need.

How-to Index

No.TopicMembership Requirement
11. Enter the PERCENTOF functionFree
22. Fill in arguments with syntax promptsFree
33. Use cross-sheet references in the formulaFree
44. Check automatic result updatesFree

How-to Guide

1. Enter the PERCENTOF function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = in the formula bar or directly in the cell.
  3. Continue by typing PERCENTOF(.
  4. Confirm that the function is in editing mode and get ready to enter the required arguments.

Success Criteria

  • On-screen result: The cell is in formula editing mode and shows =PERCENTOF(.
  • What you can do next: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: The target cell must be editable.

2. Fill in arguments with syntax prompts

Entry point: Function input prompt in the formula bar

  1. After typing PERCENTOF(, look at the syntax prompt that appears.
  2. Check the required number of arguments, their order, and the separator format.
  3. Enter the correct argument values.
  4. Press Enter to finish the calculation.

Success Criteria

  • On-screen result: The cell returns a calculated result instead of staying in an unfinished input state.
  • What you can do next: You can select the cell again to review or edit the formula.

Tips While Using

  • Common mistake: Missing a closing parenthesis or separator can cause a formula error.

3. Use cross-sheet references in the formula

Entry point: Formula bar

  1. Select the target result cell and type =PERCENTOF(.
  2. Move to the worksheet that contains the source value you want to reference.
  3. Select the needed cell or type the reference manually.
  4. Complete the remaining arguments and press Enter.

Success Criteria

  • On-screen result: The formula includes a cross-sheet reference.
  • What you can do next: You can change the referenced cell and observe whether the result changes.

Tips While Using

  • Common mistake: Referencing the wrong worksheet or cell can produce an incorrect result.
  • Environment note: The referenced worksheet must be accessible in the current file.

4. Check automatic result updates

Entry point: A completed PERCENTOF result cell

  1. Finish entering the PERCENTOF formula and confirm that a result appears.
  2. Change one of the source cells used by the formula.
  3. Return to the result cell and review the updated value.
  4. Adjust the arguments again if needed and confirm the result.

Success Criteria

  • On-screen result: The result cell updates after the source data changes.
  • What you can do next: You can save, copy, or extend the formula further.

Tips While Using

  • Common mistake: If a source value is stored as text instead of a number, the calculation may not behave as expected.