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?
<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>
<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>
=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 Location | Order Number | Bill-to Name | qty open | Part Number | Anticipated Ship Date | Outsource 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 | Address | DFTDN2 | 498362 | NO CHARGE/REPLACEMENTS | 2 | APRS18UNIT2 | 1/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>