Re: [office-formula] Constraints and infix ^

From
Andreas J Guelzow <>
Date
2009-01-13T16:45:12+00:00
ID
1231865094.448.5.camel@localhost
Thread
Re: [office-formula] Constraints and infix ^
On Tue, 2009-01-13 at 11:26 -0500, Patrick Durusau wrote:
> Greetings!
> 
> Just a quick note to check my understanding of the "constraint" listing 
> for each function.
> 
> Under 6.3.5 Infix Operator "^"
> 
> Constraints: OR(Left != 0; Right != 0)

This is the same as:
not (Left == 0 and Right == 0)

so the only thing prohibited is 0^0. 
0^(some non-zero number)  and (some non-zero number)^0 are both allowed.

> 
> Am I reading that correctly to prohibit both, 0^(some number) as well as 
> (some number)^0?
> 
> It has been a while but I seem to recall that (some number)^0 is valid, 
> although it simply returns 1.
> 
> Yes?

No :-)
> 
> Or have I mis-read the constraint notation?

yes :-)

Andreas

-- 
Andreas J Guelzow <>
Concordia University College of Alberta