Need to add another condition to existing function...but where?

[jmpatrick]

Here's what I have:

=IF(OR(ISNUMBER(SEARCH({"*1114M*","*1110*","*1109M*","*1091*"},$C5))),"No Floors",IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR","SLAB"},H5))),"Slab",IF(OR(ISNUMBER(SEARCH({"Open Web"},$H5))),"Open Web","Floor Plans"))))

This works but I need to add one more condition, a check to see if an asterisk is present in $BR5. If it is then "Floor Plans" should be displayed. Here's the additional code but I'm not sure where to insert it:

,IF(OR(ISNUMBER(SEARCH("~*",$BR5))),"Floor Plans"

What seems to be tripping me up is "Floor Plans" should be the result if NONE of the conditions are met.

I'm stumped.

 

[Fluff]

Ok how about

=IF(ISERR(SEARCH("~*",BR5)),"No Floors",IF(OR(ISNUMBER(SEARCH({"1114M","1110","1109M","1091"},$C5))),"No Floors",IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR","SLAB"},H5))),"Slab",IF(ISNUMBER(SEARCH({"Open Web"},$H5)),"Open Web","Floor Plans"))))

 

[jmpatrick]

Once again, you led me to the water! I had to tweak it slightly, but it works:

=IF(OR(ISNUMBER(SEARCH("~*",$BR5))),"Floor Plans",IF(OR(ISNUMBER(SEARCH({"1114M","1110","1109M","1091"},$C5))),"No Floors",IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR","SLAB"},$H5))),"Slab",IF(ISNUMBER(SEARCH({"Open Web"},$H5)),"Open Web","Floor Plans"))))

I really appreciate the expertise on this site. I've learned a lot over the years by dissecting the code ideas from the members here.

Thanks.

 

[Fluff]

Glad to help & thanks for the feedback.