FVSCHEDULE(principal, schedule)

Returns the future value of an initial principal after applying compound interest rates.

principalThe present value.
scheduleThe array of interest rates.

* This function can be used to calculate future value of an investment with a variable or adjustable rate.
* The "schedule" can be numbers or blank cells.
* If "schedule" contains empty cells then these are taken as zeros (no interest).
* If "schedule" is not numeric, then #VALUE! is returned.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

1=FVSCHEDULE(1,{0.09,0.11,0.1}) = $1.33
2=FVSCHEDULE("some text",{0.09,0.11,0.1}) = #VALUE!

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top