vendredi 13 septembre 2019

excel if and multiple and

I need some help with an excel =if and formula

I have 4 different situations with 4 different outcomes

  1. if cell N2 = 0 and A2 = "apple" then I need to print outcome AB
  2. if cell N2 < 0 and A2 = "apple" then I need to print outcome CD
  3. if cell N2 = 0 and A2 = "pie" then I need to print outcome EF
  4. if cell N2 < 0 and A2 = "pie" then I need to print outcome GH

=IF(AND(N2=0, A2="apple"), "AB", "CD", IF(AND(N2=0, A2="pie"), "EF", "GH"))

according to excel there are to many arguments in this formula

Aucun commentaire:

Enregistrer un commentaire