lundi 23 juillet 2018

Multiple IF statements in Excel with search func

the func gave me an #VALUE! on the last "if", please let me know what is the problem. The 2 first if's gave me the right answer.

IF(K20="CONV SUMMARY ROW","Cost",IF(SEARCH("open",K20),"Install",IF(SEARCH("depositor",K20),"Depositors")))

Aucun commentaire:

Enregistrer un commentaire