Multiple Condition IF/OR Statement with TEXT

spochedly

New Member
Joined
Aug 20, 2018
Messages
4
I am trying to return “Address” if late entry code does NOTcontain “yes” (preferably not case sensitive), OR if the very last column,outsource PO # = 0. If neither of those conditions are met, I would like toreturn “Clear.” I have responses for all based on this formula:

=IF(OR(AM51 = 0, C51 <> "yes"),"Address", "Clear")
However, it is returning “Address” to some that should beclear. I think this is because I need to do either a FIND or SEARCH function tosupport the OR clause. Can anyone please advise?




Date Entered
Late Entry Code
Stock LocationOrder NumberBill-to Name
qty openPart NumberAnticipated Ship DateOutsource PO #

<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"><colgroup><col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"><colgroup><col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"><colgroup><col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"><colgroup><col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;"><colgroup><col width="53" style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;"><colgroup><col width="142" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5193;"><colgroup><col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;"><colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"><tbody>
</tbody>

1/21/201 9
29908 29909 YES
AddressDFTDN2498362
NO CHARGE/REPLACEMENTS
2
APRS18UNIT21/31/2019
0

<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"><colgroup><col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"><colgroup><col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"><colgroup><col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"><colgroup><col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;"><colgroup><col width="53" style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;"><colgroup><col width="142" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5193;"><colgroup><col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;"><colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,204
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
try

=IF(OR(AM51 = 0, NOT(ISNUMBER(SEARCH("yes",C51)))),"Address", "Clear")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,646
Messages
5,549,171
Members
410,903
Latest member
natesreich
Top