SERIESSUMformula is a mathematical function used to calculate the sum of a power series of the form a1xn + a2xn+1 + ... + amxn+m-1. The formula takes four arguments: x (the value at which to evaluate the series), n (the initial exponent), m (the number of terms in the series), and a (an array or range of coefficients). The function is frequently used in finance and engineering to calculate present values and future values of cash flows and other mathematical models.
- How to use
- Examples of using
SERIESSUMformula not working?
- Similar formulas to
SERIESSUM formula with the syntax shown below, it has 4 required parameters:
- x (required):
The value at which to evaluate the series.
- n (required):
The initial exponent of the power series.
- m (required):
The number of terms in the series.
- a (required):
An array or range of coefficients for the series.
ExamplesHere are a few example use cases that explain how to use the
SERIESSUMformula in Google Sheets.
Calculate future value of an annuity
A common use of
SERIESSUM is to calculate the future value of an annuity, which is a series of equal payments made at regular intervals. For example, if you have a monthly payment of $100 for 10 years, you can use
SERIESSUM to calculate the future value of the annuity after 10 years, assuming a certain interest rate.
Calculate present value of a bond
Another common use of
SERIESSUM is to calculate the present value of a bond, which is the sum of the present values of its future cash flows. For example, if you have a bond that pays $100 per year for 10 years and has a face value of $1000, you can use
SERIESSUM to calculate the present value of the bond, assuming a certain discount rate.
Calculate depreciation schedule
SERIESSUM can be used to calculate the depreciation schedule for an asset over its useful life. For example, if you have an asset with a cost of $10,000 and a useful life of 5 years, you can use
SERIESSUM to calculate the depreciation expense for each year, assuming a certain depreciation method.
SERIESSUMnot working? Here are some common mistakes people make when using the
SERIESSUMGoogle Sheets Formula:
Incorrect number of arguments
The SERIESSUM formula requires exactly 4 arguments: x, n, m, and a. Check that all 4 arguments are included in the formula.
Invalid value for x
The value of x in the SERIESSUM formula should be a numeric value. Check that the value of x is correct.
Invalid value for n or m
The values of n and m in the SERIESSUM formula should be integers. Check that the values of n and m are correct.
Incorrect range for n or m
The values of n and m in the SERIESSUM formula should be positive integers. Check that the values of n and m are correct.
Invalid value for a
The value of a in the SERIESSUM formula should be a range reference. Check that the value of a is correct.
The following functions are similar to
SERIESSUM or are often used with it in a formula:
SUMfunction in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.
SUMIFformula is used to add up values in a range that meet a specific criterion. It can be used to sum values based on text, numbers, or dates. The formula is most commonly used in financial analysis, budgeting, and data analysis.
SUMIFSformula is a function in Google Sheets that adds the values in a specified range based on multiple criteria. It is most commonly used to sum data that meets specific criteria, such as summing sales for a particular month by region or summing expenses for a specific category and date range.
NPVfunction calculates the net present value of a series of cash flows, discounted by a specified rate. It is commonly used to determine the present value of an investment, where the cash flows represent incoming and outgoing payments. The function takes a discount rate and one or more cash flow values as input.
FVfunction calculates the future value of an investment based on periodic constant payments and a constant interest rate. It takes into account the present value of the investment, the number of periods in which the payments are made, and the compounding frequency. This formula is commonly used in financial planning and investment analysis.
You can learn more about the
SERIESSUM Google Sheets function on Google Support.