ND 003 AZ 004 WA 007 NV 11 UT 27 CA 41 MT 142 CA 150 OR 58 UT 59 AZ 60 WA 62 UT 73 CO 74 CO 88 WA 94 NV 109 HI 20 OR 55 OR 62 UT 165 WA 657 CA 58 MT 54 AZ 17 UT 29 CA 85 CO 51 AZ 56 08 State ProductID Bulk Quanity for Discount Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell Unit Price 17 55 17 55 17 55 17 55 17 55 4 00 34 99 34 99 34 99 4 00 34 99 4 00 34 99 4 00 4 00 4 00 4 00 4 00 34 99 34 99 34 99 34 99 34 99 34 99 1 66 5 00 34 99 5 00 5 00 10 Quantity Multiple Items TRUE TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE 4 S 7 12 1 1 2 8 8 4 2 16 1 5 1 2 2 10 1 3 1 3 1 12 24 2 2 10 4 TRUE TRUE TRUE FALSE TRUE FALSE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE Multi Month UT OR Bulk Order FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE TRUE FALSE Single Month CO NV Multi Month IF C8 Single Month Send Promo M20 complete the Bulk Order column on the table Be sure to appropriately use relative and absolute cell references E 7 1 3 Calculate Multi Month in cell 18 Use a Boolean formula that returns TRUE if the State cell C8 matches one of the months in the Multi Month column range 14 15 Use an OR function Copy your function down to complete the Multi Month column 5 1 4 Calculate Single Month in 1 5 Calculate Send Promo in