How to Use the PERCENTRANK.INC 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 entry path and steps to complete the task.

How-to Index

How-to Guide

1. Enter the PERCENTRANK.INC function

Entry path: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to begin the formula.
3. Continue by typing PERCENTRANK.INC(.
4. Check whether the function name and parameter prompt appear.

Success Criteria

• Interface result: The cell enters formula-editing mode and shows the function prompt.
• Next action available: You can continue entering the data range, target value, and optional parameter.

Tips While Using

• Common mistake: Do not leave out the = sign before the function name.
• Environment note: The formula must be entered in an editable cell.

2. Complete the formula with parameter prompts

Entry path: formula bar

1. After PERCENTRANK.INC(, enter the data range.
2. Type a separator and enter the target value whose rank you want to calculate.
3. Add the optional significance parameter if needed.
4. Type the closing parenthesis and press Enter.

Success Criteria

• Interface result: The cell displays a calculated result.
• Next action available: You can copy the formula to other cells for more analysis.

Tips While Using

• Common mistake: Unmatched parentheses or missing separators between arguments can cause formula errors.
• Environment note: The argument types should match the function requirements.

3. Use the function with cross-worksheet references

Entry path: formula bar + worksheet tabs

1. In the target cell, type =PERCENTRANK.INC(.
2. Switch to the worksheet that contains the source data and select the data range.
3. Return to the current worksheet and continue entering the target value or a cell reference.
4. Finish the formula and press Enter.

Success Criteria

• Interface result: The formula includes a cross-worksheet reference.
• Next action available: You can change source-sheet data and review the updated result.

Tips While Using

• Common mistake: After switching worksheets, do not forget separators or the closing parenthesis.
• Environment note: Referenced worksheet data should remain valid.

4. Check automatic recalculation

Entry path: result cell with a completed formula

1. Finish entering the PERCENTRANK.INC formula and confirm that a result appears.
2. Change any value in the data range used by the formula.
3. Watch whether the result cell updates with the data change.
4. If needed, select the result cell again to review the formula.

Success Criteria

• Interface result: The result value updates when source data changes.
• Next action available: You can continue adjusting data and comparing percentage-rank results.

Tips While Using

• Common mistake: Numbers entered as text may affect the calculation result.
• Environment note: Circular references or invalid references can affect the result.