FVSCHEDULE

FVSCHEDULE(principal, schedule)

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

principalThe present value.
scheduleThe array of interest rates.

REMARKS
* 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

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


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