Is it possible to combine more than 2 cells when looking for a particular entry in a cell and return different answers to more than 2 cells. For example, IF Cell A3 = “200”, Cell B3 >= “5600” and Cell C3 = “Unit” then return “Green” in Cell J3, and “Red” in Cell M3.
For that you would need two formulas: one in J3 and the same formula but with different outcome in M3
=IF(AND(A3=200,B3>=5600,C3="Unit"),"Green","")
and
=IF(AND(A3=200,B3>=5600,C3="Unit"),"Red","")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks