For XNPV:
Change Syntax from
XNPV( Number Rate ; NumberSequence Values ; DateSequence Dates )
to
XNPV( Number Rate ; Array Values ; Array Dates )
Add Contraints:
Number of elements in Values equals number of elements in Dates.
All elements of Values of type Number.
All elements of Dates of type Number.
All elements of Dates >= Dates[1]
Change Semantics:
From Dates, remove "The range of Values and Dates must be the same size."
Add:
If dimensions of arrays Values and Dates differ, evaluators shall match value and date pairs row-wise starting from top left.
For additional semantics see OFFICE-2227
Add formula:
With N being the number of elements in Values and Dates each, the formula is
XNPV = sum from
{i=1} to{N}
Values_i} over { left( 1 + Rate right) ^ {{Dates_i - Dates_1} over 365}
For SERIESSUM:
Change Syntax from
SERIESSUM( Number X ; Number N ; Number M ; NumberSequence Coefficients )
to
SERIESSUM( Number X ; Number N ; Number M ; Array Coefficients )
Add to Constraints:
All elements of Coefficients of type Number.
For NPV:
Change text formula to math formula:
from
If n is the number of values in the NumberSequence Value, the formula for NPV is:
NPV = sum (from i=1 to n) ( values
[i] / (1+Rate)^i)
to
With N being the number of elements in Values, the formula is
NPV = sum from{i=1}
to
{N}
{Values_i over left( 1 + Rate right) ^ i}
Add to See also: XNPV
Bug
Major