How to Use the MAXA Function in WPS on Windows

Use the MAXA function in WPS Office through 4 how-to topics, all available without membership; start from the How-to Index and follow the steps for function entry, parameter input, references, and result checks.

How-to Index

How-to Guide

1. Enter the MAXA function

Entry: Formulas tab → formula bar

1. Open your spreadsheet and select the cell where you want to enter the formula.
2. Type = in the formula bar or directly in the cell.
3. Type MAXA(.
4. Get ready to enter the function parameters.

Success Criteria

• The selected cell is in formula entry mode.
• The formula starts with =MAXA(.

Tips While Using

• Start the formula with =.
• For longer formulas, use the formula bar so the full expression is easier to review.

2. Fill in parameters with the syntax prompt

Entry: Continue editing after typing MAXA(

1. Type MAXA( and review the syntax prompt that appears.
2. Check the parameter requirements and example shown in the prompt.
3. Enter the required parameters in order.
4. Press Enter to confirm the formula.

Success Criteria

• The cell shows a calculation result.
• The formula matches the parameter guidance shown in the syntax prompt.

Tips While Using

• Check that the parentheses are paired correctly.
• Parameters are commonly separated with commas, and some versions also support semicolons.

3. Use cross-sheet references in MAXA

Entry: Formula bar

1. Select the target cell and type =MAXA(.
2. Move to the worksheet that contains the data you want to reference.
3. Select the cell or range to include in the calculation.
4. Complete the remaining parameters and press Enter.

Success Criteria

• The formula includes a reference to another worksheet.
• The result is displayed correctly in the current worksheet.

Tips While Using

• Confirm the data location in the referenced worksheet before finishing the formula.
• If the result looks incorrect, review the referenced range again.

4. Combine nested calculations and check updated results

Entry: Formula bar

1. Add another function or expression inside the MAXA formula when needed.
2. Check the order of parameters and the nesting of parentheses.
3. Press Enter to complete the formula.
4. Change the referenced data and review whether the result updates automatically.

Success Criteria

• The formula returns a result normally.
• The result changes after the source data changes.

Tips While Using

• For longer nested formulas, review the parentheses and parameters section by section.
• If needed, press F9 to trigger recalculation manually.