theasianova
New Member
- Joined
- Jun 21, 2011
- Messages
- 1
=IF(ISERROR(FIND("letter of credit",OR(O16,P16),1))=TRUE,"NO","YES")
I tried to use OR(O16,P16) to get the formula to search for both O16 and P16 to check if either cell contains "letter of credit."
The original formula works:
=IF(ISERROR(FIND("letter of credit",O16,,1))=TRUE,"NO","YES")
where this only searches one cell O16.
Are there other ways to construct this keyword search?
I tried to use OR(O16,P16) to get the formula to search for both O16 and P16 to check if either cell contains "letter of credit."
The original formula works:
=IF(ISERROR(FIND("letter of credit",O16,,1))=TRUE,"NO","YES")
where this only searches one cell O16.
Are there other ways to construct this keyword search?