I am trying write a formula where if 1 cell contains CON and the other contains ACN then return P0096076. That works fine but when i add a second condition of the same thing but with one cell being SI instead of CON to return P0096077 excel doesnt seem to accept it. I need to do this again for 2 further conditons where either AX8 or AG8 have specific other text also. This is the formula I am using when i try to do it for two for now but doesnt seem to be working. What am i missing?
=IF((AND(AX8 = "CON", AG8 = "ACN"),"P0096076"), IF((AND(AX8 = "SI", AG8 = "ACN"),"P0096077")))
Aucun commentaire:
Enregistrer un commentaire