how to use IF, LEFT, and FIND

[DataBlake]

So i want a formula that goes like
"If B2 contains "X" in the first 3 characters, 1, 2"
I can't get this for the life of me and any help would be appreciated

 

[Scott T]

I assume the 1 is the value for true and 2 is the value for false.

=IF(ISNUMBER(SEARCH("x",LEFT(B1,3))),1,2)

 

[hesam bahrani]

So i want a formula that goes like
"If B2 contains "X" in the first 3 characters, 1, 2"
I can't get this for the life of me and any help would be appreciated

=IFERROR(FIND("x",LEFT(A1,3),1),2)

 

[DataBlake]

I assume the 1 is the value for true and 2 is the value for false.

=IF(ISNUMBER(SEARCH("x",LEFT(B1,3))),1,2)

That works perfectly, tahnk you. is there also a way to incorporate OR?
So search for "X" or "R"?

 

[Scott T]

=IF(OR(ISNUMBER(SEARCH("x",LEFT(B1,3))),ISNUMBER(SEARCH("r",LEFT(B1,3)))),1,2)

 

[jtakw]

Hi,

Here's another way:

Book1
	B	C	D
2	abc		2
3	arbc		1
Sheet314

Cell Formulas
Range	Formula
D2	=IF(OR(ISNUMBER(SEARCH({"x","r"},LEFT(B2,3)))),1,2)

 

[DataBlake]

Thank you both for your quick responses, i was just missing the "," in my equation. so silly.