LARGE in WPS on Windows FAQ

Last updated:July 20, 2026

This FAQ covers 3 common question types about formula errors, syntax prompts, and unexpected results, plus a glossary of key terms.

FAQ

What should I do if the LARGE function returns an error?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses, commas, and parameter count are correct.
  3. Confirm that the referenced range contains numeric values that can be calculated.
  4. Confirm that k is greater than 0 and does not exceed the number of data points.

How do I view the parameter help for the LARGE function?

  1. Select any target cell.
  2. Type =LARGE(.
  3. Review the syntax prompt shown in the editing area.
  4. Complete the data range and rank parameter based on the prompt.

Why is the LARGE function result not correct?

  1. Check whether the referenced range is correct and does not miss or include extra data.
  2. Check whether some numbers are stored as text and convert them to numeric values if needed.
  3. Check whether the rank parameter matches your intended result, such as the 1st or 2nd largest value.
  4. If the formula is complex, test each nested part step by step.

Glossary

TermDefinition
LARGEA statistical function that returns the k-th largest value in a range or array.
arrayThe data range or array argument used by the LARGE function for calculation.
kThe rank argument in the LARGE function that specifies which largest value to return.