How to Use the PERCENTOF Function in WPS on Windows

This how-to guide includes 4 topics, all available without membership; choose a topic from the index and follow the steps to complete the task.

How-to Index

How-to Guide

1. Enter the PERCENTOF function

Entry point: Formulas tab → formula bar

1. Open AirSheet and select the cell where you want to enter the formula.
2. Type an equals sign = in the formula bar or directly in the cell.
3. Continue by typing PERCENTOF(.
4. Enter the required parameters and press Enter.

Success Criteria

• UI state: The cell displays a calculation result.
• Next actions: You can continue editing parameters or copy the formula to other cells.

Tips While Using

• Start the formula with an equals sign =.
• Make sure the parentheses are paired correctly.

2. View syntax guidance and parameter requirements

Entry point: Formulas tab → formula bar

1. Select the target cell.
2. Type =PERCENTOF(.
3. Check the syntax guidance that appears.
4. Review the parameter requirements and examples, then continue entering the formula.

Success Criteria

• UI state: Syntax guidance appears after the function is entered.
• Next actions: You can continue completing the formula based on the guidance.

Tips While Using

• If guidance does not appear, check whether the function name is spelled correctly.
• For longer formulas, use the formula bar so the full content is easier to review.

3. Use cross-worksheet references in a calculation

Entry point: Formulas tab → formula bar

1. Open the workbook that contains the related data.
2. Select the cell where you want the result to appear.
3. Enter the PERCENTOF formula and reference cells or ranges from another worksheet in the parameters.
4. Press Enter to confirm the result.

Success Criteria

• UI state: The result cell returns a calculated value.
• Next actions: After you change data in the referenced worksheet, you can check whether the result updates.

Tips While Using

• Before using cross-sheet references, confirm that the referenced cells contain valid values.
• If the result looks incorrect, check whether the reference location is correct.

4. Nest PERCENTOF with other functions

Entry point: Formulas tab → formula bar

1. Select the target cell.
2. Enter a combined formula that starts with =.
3. Add PERCENTOF to the formula and nest other functions as needed.
4. Check the parentheses and parameters, then press Enter.

Success Criteria

• UI state: The cell returns the result of the nested formula.
• Next actions: You can continue adjusting the outer or inner function parameters.

Tips While Using

• For longer nested formulas, review the parentheses in sections.
• If the result is not correct, test each sub-formula separately first.