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