samedi 27 novembre 2021

Why am I getting a value error in excel while using the ifs function?

=IFS(SEARCH("C*",A9),"Cake",SEARCH("K*",A9),"Cookies",SEARCH("B*",A9),"Bread & Bun",SEARCH("Y*",A9),"Pastry")

It works for the first criteria and returns "cake" but won't work for the others. I keep getting a #VALUE error. Can help please??

Aucun commentaire:

Enregistrer un commentaire