Re: [office-formula] PRICEMAT

[Eike Rathke <erack@sun.com>]

Hi Patrick,

On Wednesday, 2009-12-23 09:52:59 -0500, Patrick Durusau wrote:

> Constraints says:
>
>> Rate, AnnualYield, and Redemption should be greater than 0.
>>
> Err, Redemption does not appear as a parameter.
>
> Not sure in which direction the error lies but should be investigated.

Correct, Redemption is not a parameter. Furthermore, the constraints
should be reformulated as

Constraints: Rate >= 0, AnnualYield >= 0

Yes, not greater than 0, but greater than or equal to 0. If both are 0,
the return value is 100.

http://tools.oasis-open.org/issues/browse/OFFICE-2272

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature