Excel if and or statement

user_19678529 0
Viewed 53

EXCEL: Need help creating a formula that will return a true/false statement. I was thinking of using the IF/IFERROR(SEARCH) statement

Checking row to see if these conditions are true or false.

Conditions: Contains word: "yellow"

OR contains 8 number string AND 8 number string does not begin with the letter "B"

excel-2010 if-statement excel-formula excel
1 Answers

Try below formula-

=OR(ISNUMBER(SEARCH("Yellow",A1)),AND(LEN(A1)=8,LEFT(A1,1)<>"B"))

enter image description here

user_55147470
Related