Re: [office-formula] Formula Terminology

From
Andreas J. Guelzow <>
Date
2010-01-13T22:56:25+00:00
ID
1263423369.2941.9.camel@localhost
Thread
Re: [office-formula] Formula Terminology
On Wed, 2010-01-13 at 17:29 -0500,  wrote:
> 2) What happens if the constraints are violated?
> 
> Compare to RATE():
> 
>  If Nper is 0 or less than 0, the result is an error.
> 
> Do we really mean to say that constraint violations are errors in some 
> functions, but not in others?

please see  5.2: "If a constraint is not met, the function/operator
should return an Error unless otherwise noted." This issue comes up
again and again. I guess that is the drawback of mentioning common
properties and behaviour only once!

Andreas
-- 
Andreas J. Guelzow, PhD, FTICA
Mathematical & Computing Sciences
Concordia University College of Alberta