Add another criteria

[raccoon588]

=IF(ISNUMBER(SEARCH("rd",C4)),".0145-.0165",".0145-.0155")

i need to have this for "wt" OR "rd" how do i get the OR to fit into this?

 

[Fluff]

How about
=IF(OR(ISNUMBER(SEARCH("rd",C4)),ISNUMBER(SEARCH("wt",C4))),".0145-.0165",".0145-.0155")

 

[raccoon588]

Thank you so much for this

 

[Fluff]

You're welcome