Simple IF Statement

[spcalan]

For the life of me, this isn't working..

In Column J.... there will either be 2 texts included = "SEL-", or "INC-"
If neither, then it should default to "BI"

I was thinking of using this:
=IF(FIND("SEL-",J:J,1)>0,"SEL","BI")

But I need to it first check for "SEL-", then "INC-", then default to "BI"

 

[Nine Zero]

Try this

=IF(J1="SEL-,insert here what to do if SEL<insert what="" to="" do="" here="" if="" sel="">,IF(J1="INC-",<insert what="" to="" do="" here="" if="" inc="">insert here what to do if INC,"BI"))

Then drag down your column</insert></insert>

 

[jtakw]

Hi,

Do you mean if either SEL- or INC- is found in Column J range?
And is SEL- and/or INC- part of a longer text string within Column J range?