While it is true that it will return AND and OR (*+) they are still
multiplying and adding


For instance


(A1:A10="x")*(B1:B10="y")

let's say A1, A3 and A10 have x in them and B3 and B10 have y

that will give you

({TRUE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FA LSE;TRUE})*({FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FA LSE;FALSE;FALSE;TRUE})

and Boolean values when calculated will return 1 for TRUE and 0 for FALSE

so the above will return

{0;0;1;0;0;0;0;0;0;1}

when summed through either SUM or SUMPRODUCT it will return 2. So while one
can say it returns the answer that AND would give if it was applicable it
still does multiplication



--


Regards,


Peo Sjoblom

"Spiky" wrote in message
...
On Aug 1, 12:36 am, Shree wrote:
if((X)*(Y),A,B); what is the role of *.

Multiply is the obvious answer, but there is another way to put it in
complicated formulas, esp array formulas. It probably means the same
as AND in your formula. Assuming X is a calculation of some sort in
itself, same for Y.

* = AND
+ = OR