Searching for race type

[813615]

Morning guys, hope we're good.
After a bit of advice regarding a formula in a cell that looks at the type of race noted in column A1. I currently have this formula that looks for handicap races "Hcap" only but want to extend this for Novice and Maiden races too but tried different ways by adding the extra text but no success if anyone can help:
=IF(ISBLANK(A5),"",IF(ISNUMBER(SEARCH("Hcap",$A$1)),1,0))

Many thanks

[GaryRussell]

Use OR function

Code: Select all

=IF(ISBLANK(A5),"",IF(OR(ISNUMBER(SEARCH("Hcap",$A$1)),ISNUMBER(SEARCH("Nov",$A$1)),ISNUMBER(SEARCH("Mdn",$A$1))),1,0))

[813615]

Brilliant, thank you for a quick reply
Lee