O
oldjay
I give up. I can't get the correct formula
If A1 =1 And A2 OR A3 =2 then A4 =4 otherwise A4 =""
If A1 =1 And A2 OR A3 =2 then A4 =4 otherwise A4 =""
S
smartin
oldjay said:
Do be careful how you explain logical conundrums.
Strictly speaking, your question should be parsed as
If (A1 =1 And A2) OR A3 =2 then A4 =4 otherwise A4 =""
because AND takes precedence over OR.
Somehow I think you really meant
If A1 =1 And (A2 =2 OR A3 =2) then A4 =4 otherwise A4 =""
In which case I would write in A4:
T
T. Valko
Try this:
=IF(AND(A1=1,OR(A2=2,A3=2)),4,"")
=IF(AND(A1=1,OR(A2=2,A3=2)),4,"")
S
smartin
smartin said:
=IF(AND(A1=1,OR(A2=2,A3=2)),4,"")
Sorry about the cliff-hanger!
Y
YESHWANT
Hi oldjay,
try this one in A4
=if(a1=1,if(a2=2,4,if(a3=2,4,"")),"")
try this one in A4
=if(a1=1,if(a2=2,4,if(a3=2,4,"")),"")
F
FloMM2
oldjay,
Another solution:
"=IF(A1=1*AND(A2=2),4,IF(A1=1*AND(A3=2),4,""))"
hth
Another solution:
"=IF(A1=1*AND(A2=2),4,IF(A1=1*AND(A3=2),4,""))"
hth
D
David Biddulph
Perhaps you could explain to us what the AND function does for you in that
formula?
In what way does 1*AND(A=2) differ from 1*(A=2) ?
formula?
In what way does 1*AND(A=2) differ from 1*(A=2) ?