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 blank cells then these are taken as zeros (no interest).
* If "schedule" is not numeric, then #VALUE! is returned.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

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


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