How to Use the LARGE Function in WPS on Windows

This how-to guide includes 4 operation topics, all available without membership, so you can enter the LARGE function, fill in parameters, build references, and troubleshoot results step by step.

How-to Index

How-to Guide

1. Enter the LARGE function

Entry path: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want to show the result.
2. Type = to start a formula.
3. Type LARGE(.
4. Check the editing area to confirm that the LARGE function input has started.

Success Criteria

• Interface result: The cell or formula bar shows =LARGE(.
• Next action available: You can continue entering the data range and rank parameter.

Tips While Using

• Common mistake: If you do not start with =, the content may be treated as plain text.
• Environment note: You need to work in an editable worksheet cell.

2. Fill in parameters with function prompts

Entry path: target cell → formula bar

1. After LARGE(, enter the data range used for calculation.
2. Add the parameter separator, then enter the rank number to return.
3. Check that the closing parenthesis is complete.
4. Press Enter to confirm the formula.

Success Criteria

• Interface result: The target cell shows a calculated result.
• Next action available: You can copy the formula or adjust the referenced range.

Tips While Using

• Common mistake: Missing parameters, missing separators, or incomplete parentheses can cause formula errors.
• Environment note: The referenced range should contain numeric data that can be calculated.

3. Use cross-sheet references and nested formulas

Entry path: formula bar

1. In the array parameter of LARGE, select a data range from the current sheet or another sheet.
2. Combine LARGE with other functions when you need a nested formula.
3. Check that the reference range and formula structure are correct.
4. Press Enter to apply the formula and review the result.

Success Criteria

• Interface result: The formula returns a result normally, including when cross-sheet references are used.
• Next action available: You can continue adjusting the range or copy the formula to other cells.

Tips While Using

• Common mistake: Selecting the wrong sheet or range can change the result.
• Environment note: The referenced sheet must be in the current workbook and contain valid data.

4. Check errors and recalculate results

Entry path: result cell → formula bar

1. If the result looks incorrect, check the formula syntax, parentheses, and parameter order.
2. Confirm that numbers in the referenced range are not stored as text.
3. Check for circular references or a rank parameter outside the available data range.
4. If you need to refresh the result manually, press F9 to recalculate.

Success Criteria

• Interface result: After the issue is fixed, the cell shows a normal result.
• Next action available: You can continue editing, copying, or saving the worksheet.

Tips While Using

• Common mistake: Text-formatted numbers may affect the result.
• Environment note: Manual recalculation is useful when you want to refresh results immediately.