PERCENTILE.EXC in WPS on Windows FAQ

This FAQ covers 3 common question types about PERCENTILE.EXC, including argument errors, unexpected results, and batch use in worksheets.

FAQ

What should I do if PERCENTILE.EXC returns an error?

1. Check whether the data range is empty or contains values that cannot be used in the calculation.
2. Make sure the percentile argument is numeric and stays between 0 and 1 without using either endpoint.
3. If the cells contain text, spaces, or unexpected characters, clean the data and calculate again.

Why does the result look different from what I expected?

1. Confirm that the referenced data range is correct and that no cells were missed or added by mistake.
2. Make sure you are using PERCENTILE.EXC instead of another percentile or quartile function.
3. Review the syntax and arguments again, or re-enter them through the Insert Function dialog.

How can I use PERCENTILE.EXC in multiple cells?

1. Enter the correct formula in the first target cell.
2. Select that cell and drag the fill handle to copy the formula to other cells.
3. If the data range should stay fixed, use absolute references with $ in the range.

Glossary