samedi 10 septembre 2016

Use of multiple IF conditions in Excel

I'm trying to get a cell to pick a cell of data from a table using IF (Excel 2010, can't do IFS), but when I try to nest more than 2 IF, it returns a "too many arguments" error. Formula at this point:

=IF(B11="Humain",VLOOKUP(COO,Fonctions!A88:M110,2,FALSE),IF(OR(B11="Hybride Naturel",B11="Géno-Hybride"),VLOOKUP(COO,Fonctions!A88:M110,3,FALSE)))

Where am I doing it wrong? :/

Aucun commentaire:

Enregistrer un commentaire