I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved.
=IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("B/W",[Cost Option]1))), "B&W Impressions", IF(AND(Folder1="default",[Cost Category]1="Paperstock", [Cost Option]1="8.5x11 White"), "White Paper", IF(AND(Folder1="default",[Cost Category]1="Finishing"), "Supplies", IF(AND(Folder1="default", [Cost Category]1="Paperstock", OR([Cost Option]1="8.5x11 Yellow",[Cost Option]1="8.5x11 Green",[Cost Option]1="8.5x11 Ivory", [Cost Option]1="8.5x11 Goldenrod",[Cost Option]1="8.5x11 Blue",[Cost Option]1="8.5x11 Lilac", [Cost Option]1="8.5x11 Pink",[Cost Option]1="8.5x11 Salmon")), "Color Paper", IF(OR(ISNUMBER(FIND("Cardstock",[Cost Option]1)), ISNUMBER(FIND("Cover",[Cost Option]1)), [Cost Option]1="11x17 White", ISNUMBER(SEARCH("11 X 17 32#/80# Premium Plain Text",[Cost Option]1))), "Specialty Paper", IF(OR(ISNUMBER(FIND("Board",[Cost Option]1)), ISNUMBER(FIND("Yard Sign",[Cost Option]1))),"Poster/Signage", IF(Folder1="Business Card Billing", "Business Card", IF(AND(Folder1="Paper & Specialty Items Available for Ordering", Item1=".WCB Scantron Forms"), "Scantrons", IF(Folder1="Paper & Specialty Items Available for Ordering", "Purchased Paper", IF(AND([Cost Category]1="Additional", [Cost Option]1<>""), "Specialty Order", IF(AND([Cost Category]1="Additional",ISBLANK([Cost Option]1)),"Ignore","Problem"))))))))))))))
I hope there is an easier way, please divulge.
Angela
