Difference between revisions of "Manuals/calci/FVSCHEDULE"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
FVSCHEDULE(Principal, Schedule) | FVSCHEDULE(Principal, Schedule) | ||
| − | *Argument <math>Schedule</math> can be a numeric value. | + | *Argument <math>Schedule</math> can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message. |
| − | *Blank cells in | + | *Blank cells in the array of <math>Schedule</math> argument are considered to be zero (0). |
== Examples == | == Examples == | ||
Revision as of 14:37, 27 February 2014
FVSCHEDULE(Principal, Schedule)
Where
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Principal} represents the present value, and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Schedule} represents the array of interest rates to apply.
FVSCHEDULE() calculates the future value of an initial principal after applying a series of compound interest rates.
Description
FVSCHEDULE(Principal, Schedule)
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Schedule} can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message.
- Blank cells in the array of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Schedule} argument are considered to be zero (0).
Examples
Consider the following example that shows the use of FVSCHEDULE function: