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 "Packages"
=LET(boxes, COUNTIF(D8:D40, "*Box*"), bags, COUNTIF(D8:D40, "*Bag*"), IFS(AND(boxes, bags), "Packages", boxes, "Box(es)", bags, "Bag(s)", TRUE, "None"))
