2

There are three columns. A, B and results.
I need to make a formula that gives the following:

If the text in both columns A and B is WIN, then in the results we should see: Winner.
If the text in column A is WIN and in B is LOSE, then in results we should see: Try again
If the Text in both columns A and B is LOSE, then in results we should see: Loser.

1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Dec 22, 2019 at 10:44

1 Answer 1

1

The formula you need is:

=IFERROR(ArrayFormula(
     IF((M13:M16="WIN")(N13:N16="WIN"),"Winner",
     IF((M13:M16="WIN")(N13:N16="LOSE"),"Try again",
     IF((M13:M16="LOSE")*(N13:N16="LOSE"),"Loser","")))))

enter image description here

Please adjust columns and cell numbers to your needs

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.