ExcelFlux

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

RowABC
6InputSecond inputThird input
7211
8311
9411
Record 1
=SERIESSUM(A7,0,1,B7:C7)

Illustrative output3

See the inputs and instructions for all 3 examples

Worked 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
Microsoft Excel reference