Syntax
=SERIESSUM(x, n, m, coefficients)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The input value |
n | Required | The first power of x |
m | Required | The step added to the power for each term |
coefficients | Required | The coefficients a1, a2, ... |
How to use SERIESSUM
SERIESSUM takes 4 required arguments. Type =SERIESSUM( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=SERIESSUM(2, 1, 1, {1,2,3})Result =SERIESSUM(PI()/4, 0, 2, {1,-0.5,0.041666667,-0.001388889})Result Related math functions
- ROUNDDOWNRounds a number toward zero to a given number of digits.
- ROUNDUPRounds a number away from zero to a given number of digits.
- SECReturns the secant of an angle given in radians.
- SECHReturns the hyperbolic secant of a number.
- SIGNReturns 1 for a positive number, -1 for a negative number and 0 for zero.
- SINReturns the sine of an angle given in radians.
- SINHReturns the hyperbolic sine of a number.
- SQRTReturns the square root of a number.
- SQRTPIReturns the square root of a number multiplied by pi.