EXCEL SERIESSUM FUNCTION

The Excel Seriessum function returns the sum of a numerical method based on the power linear system shown below:

Syntax :

=SERIESSUM( xnmcoefficients )

Parameters :

  • The following parameter are:

x –

  • The power series’s input value.

n –

  • The initial power to which x will be increased.

m –

  • The step size by which n is increased with each succeeding power of x.

coefficients –

  • A collection of coefficients that multiply each consecutive power of x.

Step By Step Guide of SERIESSUM Function

Example :

The Excel Seriessum formula is used to determine the power series in the worksheet below:

  • #VALUE! – This error occurs if any of the supplied parameters is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now