How to Use the LARGE Function in WPS on Windows

Last updated:July 23, 2026

Use the LARGE function in 3 how-to topics: create a formula field and call LARGE, understand the parameter format, and review a basic example; 3 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use LARGEFree
22. Understand the LARGE parameter formatFree
33. Review a basic LARGE exampleFree

How-to Guide

1. Create a formula field and use LARGE

Entry: Add Field → Formula

  1. Open the multi-dimensional table you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes LARGE in the formula editor.
  5. Click Confirm and check whether the result appears in the new field.

Success Criteria

  • Interface result: A new formula field appears in the table and shows a calculated result.
  • Next action available: You can continue editing the formula or adjust the referenced range.

Tips While Using

  • Make sure the referenced range contains numeric values that can be calculated.
  • If the result looks wrong, check the function name, commas, parentheses, and parameter order first.

2. Understand the LARGE parameter format

Entry: Formula Editor → Function Library → LARGE

  1. Open the function library in the formula editor.
  2. Select LARGE to view its syntax.
  3. Fill in the target data range in the first parameter position.
  4. Enter the rank value you want to return in the second parameter position.
  5. Save the formula after confirming the syntax is correct.

Common format:

LARGE(data range, rank value)

Success Criteria

  • Interface result: The formula editor recognizes the LARGE syntax correctly.
  • Next action available: After saving, you can return to the table and review the result.

Tips While Using

  • The rank value should match the amount of valid data in the target range.
  • If the parameter type does not match the expected input, the formula may return an error.

3. Review a basic LARGE example

Entry: Formula Field → Enter Formula

  1. Select an existing formula field or create a new one.
  2. Enter an example such as LARGE(A1:A100, 3).
  3. Save the formula and review the returned result.
  4. Change the rank value to 1, 2, or another number to compare different outputs.
  5. Combine it with other functions if needed.

Success Criteria

  • Interface result: The formula returns the nth largest value from the target range.
  • Next action available: You can reuse the same approach in other fields or records.

Tips While Using

  • The example range should be adjusted to match your actual table structure.
  • If the source data changes over time, the formula result can change with it.