In 2 cells I have different vallues . eg: in A2 "Poultry" and B2 "Fish" or vice versa , if this combination comes together i want C2 to read "Not approved" otherwise "OK"
Please advise with the formula
In 2 cells I have different vallues . eg: in A2 "Poultry" and B2 "Fish" or vice versa , if this combination comes together i want C2 to read "Not approved" otherwise "OK"
Please advise with the formula
hi Napa. maybe:
=IF(OR(AND(A2="Poultry",B2="Fish"),AND(A2="Fish",B2="Poultry")),"Not Approved","OK")
or:
=IF(SUM(COUNTIF(A2:B2,{"fish","poultry"}))=2,"Not Approved","OK")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks a lot Benshiryo. the first one is appropriate in my case !
Maybe..
=IF(AND(ISNUMBER(MATCH("Fish",A2:B2,0)),ISNUMBER(MATCH("Poultry",A2:B2,0))),"Not Approved","OK")
Life's a spreadsheet, Excel!
Say thanks, Click *
or another one
array entered
Formula:Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks