vendredi 19 juillet 2019

Excel IF statements "if cell contains" multiple output options

In Excel - if I have a cell (Ex: A1) that I can input either "2x6 DF#2","4x6 Borate", or "3x6 ACQ". . .basically any entry that contains either the text "DF", "Borate", or "ACQ". . .and I want Cell B1 to output "BF" I am using the following equation successfully:

=IF(OR(ISNUMBER(SEARCH("DF",A1)),ISNUMBER(SEARCH("Borate",A1)),ISNUMBER(SEARCH("ACQ",A1))),"BF","")

If I want the above stipulations to still be true. . .but I also want to be able to have the option of inputing "4x8 CDX", "2x6 OSB S1", "4x9 FRT PLY". . .basically any entry that contains either the text "CDX", "OSB", or "PLY". . . to output "SF" into Cell B1 - how do I accomplish that?

I would basically like a way that I can combine both of the following formulas. . .

=IF(OR(ISNUMBER(SEARCH("DF",A1)),ISNUMBER(SEARCH("Borate",A1)),ISNUMBER(SEARCH("ACQ",A1))),"BF","")

=IF(OR(ISNUMBER(SEARCH("CDX",A1)),ISNUMBER(SEARCH("OSB",A1)),ISNUMBER(SEARCH("PLY",A1))),"SF","")

Thank you for your help

Aucun commentaire:

Enregistrer un commentaire