Add another criteria

raccoon588

Board Regular
Joined
Aug 5, 2016
Messages
118
=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?
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,649
Office Version
365
Platform
Windows
How about
=IF(OR(ISNUMBER(SEARCH("rd",C4)),ISNUMBER(SEARCH("wt",C4))),".0145-.0165",".0145-.0155")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,649
Office Version
365
Platform
Windows
You're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,102,334
Messages
5,486,218
Members
407,537
Latest member
Frank Nunez

This Week's Hot Topics

Top