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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
3,981
Office Version
365, 2019, 2016
Platform
Windows
try

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

Watch MrExcel Video

Forum statistics

Threads
1,102,218
Messages
5,485,442
Members
407,501
Latest member
DannyLee

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top