Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSchedule to calculate the future value of an investment with a variable or adjustable rate.
Syntax
expression.FVSchedule (Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Principal - the present value. |
| Arg2 | Required | Variant | Schedule - an array of interest rates to apply. |
Return value
Double
Remarks
The values in schedule can be numbers or blank cells; any other value produces the #VALUE! error value for FVSchedule. Blank cells are taken as zeros (no interest).
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.