Formulas > =FVSCHEDULE()
How to Use FVSCHEDULE() in Google Sheets
Description
How To Actually Use FVSCHEDULE() in Sheets
FVSCHEDULE(principal, rate_schedule)
Try FVSCHEDULE yourself
In cells A1 to A5, enter the principal amount in A1 and a series of interest rates in A2 to A5. Use the FVSCHEDULE formula in cell B1 to calculate the future value based on these rates.
Hints (3)
-
Make sure to enter the principal as a single value in A1.
-
The interest rates should be in percentage format.
-
Ensure the range for the rates is correct in your formula.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the FVSCHEDULE() formula:
Generate a FVSCHEDULE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses FVSCHEDULE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a FVSCHEDULE() formula