Another "2 formulas in 1 cell" question...

[jmpatrick]

I have this in cell K5:

=IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab","Floor Plans")

I would like to combine that with this:

=IF(OR(ISNUMBER(SEARCH({"Open Web"},$G5))),"Open Web","Floor Plans")

I ended up with this, but it gives me a #VALUE!:

=IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab","Floor Plans"),IF(OR(ISNUMBER(SEARCH({"Open Web"},$G5))),"Open Web","Floor Plans")

Not sure if I need IF or IFS...

 

[mikerickson]

Try
=IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab",IF(OR(ISNUMBER(SEARCH({"Open Web"},$G5))),"Open Web","Floor Plans"))

 

[Scott Huish]

=IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab",IF(ISNUMBER(SEARCH("Open Web",$G5)),"Open Web","Floor Plans"))

 

[Fluff]

How about
=IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab",IF(ISNUMBER(SEARCH("Open Web",$G5)),"Open Web","Floor Plans"))

 

[jmpatrick]

Thanks, everyone! First one worked.

 

[Scott Huish]

The difference between the first one and the last 2 is that OR is not necessary for only checking 1 condition.