OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] PRICEMAT

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.



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

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]