testing for left 2 characters in set of 3 choices
Use your formula like the below:-
=IF(OR(LEFT(A1,2)="CD",LEFT(A1,2)="EF",LEFT(A1,2)= "GH"),"TRUE 1","FALSE 2")
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"MusicMan" wrote:
following returns true even if false
a1=ab1234
b1=if(left A1,2)=or("cd","ef","gh"),1,2) test if A1=cd or ef or gh, true
1, false 2
the above should return 2 false but returns 1 true in error?
I tried formula evaluation and it shows "ab"=false but then evalutes
combined to true in error.
|