Nested If Statement

[ExcelYetti]

Hello

I'm trying to write a statement that does the following: If cell B4 contains the letter G, or F fill cell D6 with the word Included, if not leave D6 blank (G or F in B4 can be stand alone or within a string of characters/part number).

To the best of my knowledge the way to achieve this is a nested if statement. Here's what I have now in D6. It identify's the G, however, if there is no G, but an F it's not recognized the F.

=IF(ISNUMBER(SEARCH("G",B4)),"Included",IF(ISNUMBER(SEARCH("F",B4,)),"Inc",""))

Thanks in advance!

 

[Joe4]

Welcome to the Board!

You have an extra comma after the B4 in your second IF statement.
Remove that and it will work.

 

[Eric W]

You could also try this:

=IF(MIN(SEARCH({"F","G"},B4&"fg"))<=LEN(B4),"Included","")

 

[philaugust2004]

Welcome to the Board!

You have an extra comma after the B4 in your second IF statement.
Remove that and it will work.

I came up with same formula as OP but mime worked and I could not for the life of me spot what the difference was. I even used the EXACT formula and it said FALSE so I knew there was a difference

 

[ExcelYetti]

Hello

Removing the comma worked! Thanks everyone!