SMALL function seems not to work correctly
On Feb 16, 1:33 am, Ron Rosenfeld wrote:
On Fri, 15 Feb 2008 19:16:47 -0500, Ron Rosenfeld
wrote:
Your thinking that the multiplication operator should be interpreted as an
addition operator is incorrect
That statement is incorrect.
You wrote that you thought the "*" should be interpreted as an AND. In fact,
it is (kind of) being interpreted that way. Where you were incorrect was in
equating the AND operation to ADDITION (summing). In point of fact, an AND
argument equates to multiplication. For AND to be true, both arguments must be
true. So, for example:
expr1 expr2 result
0 0 0
0 1 0
1 0 0
1 1 1
As you can see, result is the the result of expr1 * expr2
--ron
Ron, thanks for taking the time to clear it up - I understand now.
Hector
|