This FAQ covers 3 common questions about using MAXA in WPS Spreadsheet on Windows, along with key terms for quick reference during formula entry and troubleshooting.
FAQ
What should I do if MAXA returns an unexpected result?
- Check whether the parentheses, separators, and number of arguments are complete.
- Confirm that the referenced range matches the calculation you want.
- Re-enter the arguments through the Insert Function dialog box and verify each argument position.
Why does the MAXA result not match what I expected?
- Check whether the selected cell range is correct.
- Review whether the data being calculated includes logical values, text, or blank cells.
- Compare your formula with the syntax guidance and verify the argument setup again.
How do I use the MAXA function in multiple cells?
- Enter the MAXA formula in the first target cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag the fill handle down or across, or copy and paste the formula into other cells.
Glossary
| Term | Definition |
|---|---|
| MAXA | A WPS Spreadsheet function that returns the largest value from its arguments. |
| Insert Function | The dialog-based entry for searching, selecting, and filling in function arguments in a worksheet. |
| Formula bar | The input area above the worksheet where you can enter or edit formulas directly. |