How to Use the PERCENTILE.INC Function in WPS on Windows

This how-to guide includes 4 topics for using PERCENTILE.INC, covering function entry, argument input, cross-sheet references, and nested calculation updates; 4 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Enter the PERCENTILE.INC function

Entry point: Select the target cell → formula bar

1. Open WPS Spreadsheet and go to the worksheet where you want to calculate a percentile.
2. Click the result cell.
3. Type = in the cell or formula bar.
4. Continue with PERCENTILE.INC( and check the function prompt.

Success Criteria

• Interface result: The selected cell enters formula editing mode.
• Next action available: 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 function name should be entered in spreadsheet formula format.

2. Fill in arguments and return a result

Entry point: A cell or formula bar where the function name is already entered

1. In the parentheses, enter the data range first, such as A2:A10.
2. Add a comma to separate the arguments.
3. Enter the percentile value, such as 0.9.
4. Check the formula and press Enter.

Success Criteria

• Interface result: The target cell shows a calculated result.
• Next action available: You can select the cell again and review the full formula in the formula bar.

Tips While Using

• Common mistake: Missing parentheses, incorrect separators, or an invalid percentile argument can cause an error.
• Environment note: The input range should contain valid numeric data.

3. Use a cross-sheet reference

Entry point: Target result cell → formula bar

1. Enter =PERCENTILE.INC( in the target cell.
2. Switch to the worksheet that contains the source data and select the range.
3. Return to the formula and add the percentile argument.
4. Press Enter to finish the cross-sheet calculation.

Success Criteria

• Interface result: The formula includes worksheet reference information.
• Next action available: You can review the result again after source data changes.

Tips While Using

• Common mistake: An incomplete selected range can affect the result.
• Environment note: The referenced worksheet should keep a valid data range.

4. Build a nested formula and refresh results

Entry point: Target cell → formula bar

1. Insert PERCENTILE.INC into an existing formula as one part of a larger calculation.
2. Combine it with other functions as needed.
3. Check that all parentheses and argument levels are correct.
4. Change the source data and review whether the result updates.

Success Criteria

• Interface result: The nested formula returns a valid result.
• Next action available: The result can be recalculated after source data changes.

Tips While Using

• Common mistake: It is easy to miss a parenthesis in a more complex nested formula.
• Environment note: For longer formulas, review the full structure in the formula bar.