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