When using SERIESSUM, the most common issues fall into 3 areas: function entry, argument completion, and result checking; below are 4 frequently asked questions and practical fixes.
FAQ
Why does SERIESSUM not return a result after I enter it?
- Confirm that you typed
=before the function. - Check whether the current cell is editable.
- Make sure you pressed Enter after finishing the formula.
- If there is still no result, re-enter the function and check whether syntax guidance appears.
What should I check first when the SERIESSUM function shows an error?
- First, check whether the parentheses are paired correctly.
- Then check whether the number and order of arguments are complete.
- Confirm that the separators between arguments are correct.
- If cell references are included, check whether the referenced addresses are valid.
Why does the calculation result look incorrect?
- Check whether the cells used in the calculation contain numbers stored as text.
- Check whether the formula references the wrong worksheet or range.
- Confirm that there is no circular reference or logic issue in a nested formula.
- After making changes, calculate again and review the result.
Can I use SERIESSUM with other functions?
- Yes. You can enter other functions inside the argument positions to create a nested calculation.
- While entering the formula, make sure both the outer and inner parentheses are complete.
- It is recommended to verify the inner function first before combining it with SERIESSUM.
- When finished, press Enter to view the final result.
Glossary
| Term | Definition |
|---|---|
| SERIESSUM | A function name in AirSheet used to return a calculated result in power series form. |
| Syntax guidance | The prompt area that appears after you enter a function name and helps you fill in the formula. |
| Cross-sheet reference | A way to reference data from a cell on another worksheet in the current formula. |
| Nested calculation | A formula pattern where another function is used inside the arguments of a function. |