View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hdf hdf is offline
external usenet poster
 
Posts: 30
Default 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