Ampersand as a logical operator in Excel?

[katarina07]

Hello,

I have a file with a situation similar to this:

value in the cell A1 is 1
value in the cell A2 is 1

The following formulas provide the following outcomes:

Formula = (A1>0 & A2>0) ; Outcome = True
Formula = (A1<0 & A2<0) ; Outcome = False
Formula = (A1>0 & A2<0) ; Outcome = False
Formula = (A1<0 & A2>0) ; Outcome = True

How should I understand these outcomes? I thought the ampersand means either "AND" or "OR" in these formulas, but the outcomes dont correspond to it.

Thanks
Katarina

 

[Norie]

Katarina

The & is not a logical operator.

It's used for concatenation of strings.

Try AND.

=AND(A1>0, A2>0)

 

[Diffy]

Hi, I would use the and() function: =and(A1>0, A2>0).

You can also use the or() function as well.