How to Use the MAX Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics, all available without membership, so you can quickly jump from the index to the steps you need.

How-to Index

#TopicMembership
11. Enter the MAX functionFree
22. Fill in the formula argumentsFree
33. Review and verify the resultFree

How-to Guide

1. Enter the MAX function

Entry point: Add Field → Formula, or enter the function directly in the spreadsheet formula input area

  1. Open the data sheet you want to calculate.
  2. Select the cell or formula field where the result should appear.
  3. Type =MAX().
  4. Keep the cursor inside the parentheses so you can enter the arguments.

Success Criteria

  • UI state: The formula input area shows =MAX().
  • Next actions: You can continue entering a range or multiple numeric arguments.

Tips While Using

  • Common mistakes: If you do not select the result cell first, the output may appear in an unexpected location.
  • Environment limits: The values used in the calculation should be numeric.

2. Fill in the formula arguments

Entry point: Formula editor → enter arguments

  1. Inside MAX(), enter the target range, such as A1:A100.
  2. If needed, enter multiple values or ranges separated by commas.
  3. Check that the parentheses, separators, and references are complete.
  4. Press Enter or confirm to save the formula.

Success Criteria

  • UI state: The formula appears in a complete format such as =MAX(A1:A100).
  • Next actions: The sheet can return a calculation result immediately.

Tips While Using

  • Common mistakes: Incomplete separators or non-numeric references may affect the result.
  • Environment limits: The arguments should match the actual fields or cell ranges in your data.

3. Review and verify the result

Entry point: Result cell or formula field display area

  1. After entering the formula, check the result area.
  2. Compare the returned value with the source data to confirm it is the current maximum.
  3. Change the source data and see whether the result updates.
  4. If the result looks incorrect, check the argument format and data type again.

Success Criteria

  • UI state: The result area shows the largest value in the current data set.
  • Next actions: After source data changes, the result can refresh accordingly.

Tips While Using

  • Common mistakes: Treating text-formatted numbers as numeric values may affect result checks.
  • Environment limits: If the referenced range is empty or has no valid numbers, interpret the result based on the current data state.