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.

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos Dec 22 '19 at 10:44
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

| improve this answer | |
  • Thanks for the help. – Allan Alonso Dec 22 '19 at 17:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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