[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. 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.