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

This guide includes 3 how-to topics for using PERCENTILE.EXC in WPS Spreadsheet, and all 3 are available without membership.

How-to Index

How-to Guide

1. Enter the function through the Insert Function dialog

Entry point: Formula tab → Insert Function

1. 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 Formula tab.
3. Search for PERCENTILE.EXC in the dialog box.
4. Select the function and click OK.
5. Enter the data range and percentile argument in the Function Arguments dialog box.
6. Click OK to finish.

Success Criteria

• On-screen result: The target cell displays a calculated PERCENTILE.EXC result.
• What you can do next: You can edit the arguments, copy the formula, or fill it down to other cells.

Tips While Using

• Common mistake: The percentile argument must be a number between 0 and 1, excluding both endpoints.
• Environment note: If the referenced range is empty, the formula may return an error.

2. Type the formula directly in a cell

Entry point: Worksheet cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =PERCENTILE.EXC(array,k) directly in the cell or in the formula bar.
3. Replace array with your data range and k with the target percentile.
4. Press Enter to confirm.
5. If needed, drag the fill handle to copy the formula to other cells.

Success Criteria

• On-screen result: The cell returns the percentile result or a recognizable error message.
• What you can do next: You can keep adjusting the range reference and percentile argument in the formula bar.

Tips While Using

• Common mistake: A wrong range reference, text-type arguments, or punctuation issues can cause formula errors.
• Environment note: When copying the formula, check whether relative and absolute references match your intended result.

3. Check syntax and parameter details

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Search for PERCENTILE.EXC.
3. Select the function to review its syntax and parameter details.
4. Check whether the data range and percentile argument are entered in the correct format.
5. Open the related help entry if you need more details.

Success Criteria

• On-screen result: You can see the function name, syntax structure, and parameter description area.
• What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

• Common mistake: Checking only the function name without confirming the valid percentile range can lead to #NUM! or #VALUE!.
• Environment note: Some help content may require an internet connection to open fully.