Edit

Share via


WorksheetFunction.FVSchedule(Object, Object) Method

Definition

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.

public:
 double FVSchedule(System::Object ^ Arg1, System::Object ^ Arg2);
public double FVSchedule (object Arg1, object Arg2);
Public Function FVSchedule (Arg1 As Object, Arg2 As Object) As Double

Parameters

Arg1
Object

Principal - the present value.

Arg2
Object

Schedule - an array of interest rates to apply.

Returns

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).

Applies to