How to Use the LARGE Function in WPS on Windows

Last updated:July 20, 2026

This section includes 3 how-to topics for entering the LARGE function, checking syntax prompts, and combining references or nested formulas; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Enter the LARGE function and return a resultFree
22. Check the LARGE function syntax promptFree
33. Use LARGE with references or nested formulasFree

How-to Guide

1. Enter the LARGE function and return a result

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want to show the result.
  2. Type = to start the formula.
  3. Type LARGE(.
  4. Enter the data range and rank parameter, for example LARGE(A2:A10,2).
  5. Press Enter to confirm and display the result in the current cell.

Success Criteria

  • Interface result: The cell shows the calculated k-th largest value.
  • Next action available: You can copy the formula, change parameters, or fill it into other cells.

Tips While Using

  • Common mistake: If the parameter count is incomplete, parentheses are not closed, or the rank exceeds the number of data points, the formula may return an error.
  • Environment note: The referenced range should contain recognizable numeric values.

2. Check the LARGE function syntax prompt

Entry point: Formulas tab → formula bar

  1. Select the target cell.
  2. Type =LARGE(.
  3. Watch the editing area for the syntax prompt.
  4. Fill in the data range and rank parameter based on the prompt.

Success Criteria

  • Interface result: A parameter prompt appears after you enter the function name.
  • Next action available: You can continue completing the formula and calculate the result.

Tips While Using

  • Common mistake: Entering only the function name without completing the parameters will not return a valid result.

3. Use LARGE with references or nested formulas

Entry point: Formulas tab → formula bar

  1. Open the worksheet that contains the source data and confirm the range you want to reference.
  2. Enter the LARGE formula in the target cell and add cross-sheet references if needed.
  3. If you need a more complex calculation, combine LARGE with other functions.
  4. Press Enter and confirm that the result updates when the source data changes.

Success Criteria

  • Interface result: The formula result displays correctly, and updates after source data changes.
  • Next action available: You can expand the formula into a more advanced calculation.

Tips While Using

  • Common mistake: An incorrect reference range can produce unexpected results.
  • Environment note: When using cross-sheet references, confirm that the worksheet name and range are written correctly.