Modifying a Formula 1

[jatolo]

This formula is working PERFECT....
=IF((P4=1)*(R4=1)*AND(T4=1),1,0)

NOW I NEED TO ADD "C1"... I MEAN...
P4="1 RA4=1 T4=1,1,0
P4="C1" RA4=1 T4=1,1,0
P4=1 RA="C1" T4=1,1,0
P4=1 RA=1 T4=C1,1,O
P4"C1" RA"C1" T4"C1",1,0... in other words count "c1" as 1
thank you!!

Thanks....
Jatolo

 

[SkipVought]

hi,

your formula is really NOT correct. The AND function works like this (check HELP)
[tt]
AND(expression₁,expression₂...,expression_n)
[/tt]
So I suspect that you wanted this...
[tt]
=IF(AND((P4=1),(R4=1),(T4=1)),1,0)
[/tt]
Now then, the new requirment is that P4 must either be 1 OR "C1", etc. So we will have ORs within the AND, and I will also remove the unnecessary parentheses...
[tt]
=IF(AND(OR(P4=1,P4="C1"),OR(R4=1,R4="C1"),OR(T4=1,T4="C1")),1,0)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jatolo]

Thank you SKIPVOUGHT!!

Thanks....
Jatolo