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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

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,840
Messages
5,489,196
Members
407,677
Latest member
Matt1989

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top