katarina07
New Member
- Joined
- Oct 27, 2005
- Messages
- 20
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
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