MAX in WPS on Windows FAQ

This FAQ covers 3 common question types about formula errors, argument entry, and result checks when using MAX in WPS on Windows.

FAQ

Why does the MAX function return an error after I enter it?

1. Check whether the formula starts with =.
2. Check whether the parentheses, commas, and references are complete.
3. Confirm that the referenced fields or cells contain numeric values that can be calculated.

Can I use MAX together with other functions?

1. Confirm that the outer and inner functions use compatible argument types.
2. If MAX is used as an argument inside another function, test MAX by itself first.
3. After combining formulas, check the parenthesis levels and argument order again.

Will the MAX result update after I change the source data?

1. If the formula range includes the edited cells, the result updates when the data changes.
2. After editing, compare the result with the source data again to confirm the current maximum.
3. If the result does not change, check whether the edited data is inside the referenced range.

Glossary