Hi Eric,
On Saturday, 2010-01-16 00:02:25 +0000, Eric Patterson wrote:
> Attached is the proposed updated to the XNPV function for Office-2227.
Thanks. Please see also
http://tools.oasis-open.org/issues/browse/OFFICE-1075
for additional changes. I added that to the Proposal field.
It isn't quite clear to me what the wording "optional" in
| The first cash-flow amount is optional and corresponds to a cost or
| payment that occurs at the beginning of the investment, represented by
| a negative number.
would imply. To my understanding the first amount can't be optional but
must be present, it is an element of an Array (note: not NumberSequence,
see OFFICE-1075) argument. It think optional here means that the value
does not necessarily have to be negative. If yes, shouldn't that be
worded different?
Btw, for mathematical formulas please use a math formula object instead
of an image, and in the formula use variable names corresponding to the
parameter names.
Thanks
Eike
--
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
