SERIESSUM function
the sum of a power series based on the formula.
Math and trigonometry · Guided Excel example
Where can you use it?
Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.
Scenario in the workbook
Evaluate the power series 1+x with coefficients 1 and 1. The initial exponent is 0 and increments by 1.
A worked example from the workbook
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Second input | Third input |
| 7 | 2 | 1 | 1 |
| 8 | 3 | 1 | 1 |
| 9 | 4 | 1 | 1 |
Record 1
=SERIESSUM(A7,0,1,B7:C7)Illustrative output3
See the inputs and instructions for all 3 examplesWorked examples
Evaluate the power series 1+x with coefficients 1 and 1. The initial exponent is 0 and increments by 1.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Second input | Third input |
| 7 | 2 | 1 | 1 |
| 8 | 3 | 1 | 1 |
| 9 | 4 | 1 | 1 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =SERIESSUM(A7,0,1,B7:C7) |
3 |
| Record 2 | =SERIESSUM(A8,0,1,B8:C8) |
4 |
| Record 3 | =SERIESSUM(A9,0,1,B9:C9) |
5 |