I have a number in this inside this formula t


the formula is producing a "8020" results because the #002534 falls within the criteria.

I need to somehow make it so ONLY 002534 does not produce anything, but the rest of the range numbers are fine. I just need to somehow add a another condition to take #002534 out. 


=IF(AND(AND(ISNUMBER(SEARCH("Juice",C1622)),W1622<>"002691",W1622<>"002922",W1622<>"002479"),OR(ISNUMBER(SEARCH("Food",G1622)),ISNUMBER(SEARCH("travel",G1622)),ISNUMBER(SEARCH("Late night",G1622)),ISNUMBER(SEARCH("International",G1622))),AND(W1622<>"002831",W1622<>"002383",W1622<>"002452",W1622<>"002754",W1622<>"000896",W1622<>"002974",W1622<>"002481",W1622<>"003098",W1622<>"002467",W1622<>"003147")),8020,0)

I then need to add that #002534 to another cell formula below.


=IF(AND(NOT(ISNUMBER(SEARCH("Juice",G5))),AND(W5<>"002831",W5<>"002383",W5<>"002452",W5<>"002754",W5<>"000896",W5<>"002974",W5<>"002481",W5<>"003098",W5<>"002467",W5<>"003147")),5010,0)