what is the role of *.

  • Thread starter Thread starter Shree
  • Start date Start date
if((X)*(Y),A,B); what is the role of *.
Click to expand...

Multiply. You can find an explanation of Excel operators by looking
at the Help page for "About calculation operators". If you truly do
not understand what "*" means in this context, you would benefit from
a book on the basics of Excel.

However, I wonder if your real question is: how can X*Y result in
true or false?

The answer is: if(X*Y,...) is shorthand for if(X*Y <> 0,...). Zero
is considered FALSE, and nonzero is considered TRUE.
 
Hi

* is multiply operator.

The formula says, that when X*X<>0, then A, otherwise B
 
if((X)*(Y),A,B); what is the role of *.
Click to expand...

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
 
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;FALSE;TRUE})*({FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;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
 
Back
Top