Formula Question

[counihan3]

Is there a way to use an "OR" statement for a formula equals range. By that I mean =IF(A1=OR("A","B","C"),"T","F") If so I could shorten several of my formulas, but I don't know if there is a way.

 

[jimrward]

you are nearly there, but with a change of function to something like

=IF(ISNUMBER(SEARCH(A1,"ABCTF")),"TRUE","FALSE")

 

[Gerald Higgins]

Or, how about

=if(or(a1="a",a1="b",a1="c"),"T","F")

 

[Brian from Maui]

Will return F if A1 is empty,

=IF(OR(A1={"A","B","C"},),"T","F")