I need some help with an excel =if and formula
I have 4 different situations with 4 different outcomes
- if cell N2 = 0 and A2 = "apple" then I need to print outcome AB
- if cell N2 < 0 and A2 = "apple" then I need to print outcome CD
- if cell N2 = 0 and A2 = "pie" then I need to print outcome EF
- 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