Forum Discussion
Multiple Ifs
I am having a hard time with this multiple if If D8:D40 contains only "*Box*" return "Box(es)" If D8:D40 contains only "*Bag*" return "Bag(s)" If D8:D40 contains either "*Bag*" or "*Box*", return ...
=LET(boxes, COUNTIF(D8:D40, "*Box*"), bags, COUNTIF(D8:D40, "*Bag*"), IFS(AND(boxes, bags), "Packages", boxes, "Box(es)", bags, "Bag(s)", TRUE, "None"))