NOTE: YOU DO NOT NEED TO ANSWER ALL OF THEM. JUST SHOW ME THE STEPS ON HOW TO DO IT CORRECTLY. THANK YOU.

Using as many columns as you would like, calculate Commissions. In order to calculate it, you must first find Collections divided by Sales as a percentage for each transaction. There are three different calculations for Commissions depending on the Collections divided by Sales result. If Collection divided by Sales is greater than or equal to 75%, Commissions is 2% x Sales. If Collection divided by Sales is greater than or equal to 50% but less than 75%, Commissions is 1% x Sales. For all other transactions, Commissions is $0. You should consider logical formulas to help you solve this question.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Date 1/16/19 1/26/19 1/29/19 3/6/19 3/9/19 3/19/19 3/22/19 3/26/19 3/30/19 4/11/19 4/15/19 4/19/19 4/26/19 5/5/19 5/19/19 5/22/19 5/30/19 6/6/19 6/9/19 6/12/19 6/14/19 6/18/19 6/20/19 6/20/19 6/25/19 6/25/19 6/26/19 7/2/19 7/8/19 7/15/19 7/25/19 7/28/19 7/28/19 8/4/19 8/6/19 Salesperson SP-07 SP-14 SP-07 SP-21 SP-01 SP-18 SP-07 SP-23 SP-15 SP-14 SP-15 SP-16 SP-19 SP-06 SP-07 SP-15 SP-20 SP-12 SP-14 SP-04 SP-17 SP-09 SP-05 SP-14 SP-15 SP-21 SP-15 SP-13 SP-14 SP-16 SP-07 SP-14 SP-15 SP-21 SP-20 Customer Product Material Size CUST-085 PROD-001 MATL-Garnet SIZE-M CUST-073 PROD-001 MATL-Opal SIZE-S CUST-048 PROD-001 MATL-Amethys SIZE-XL CUST-116 PROD-001 MATL-Jade SIZE-M CUST-079 PROD-001 MATL-Copper SIZE-XL CUST-007 PROD-001 ATL-Moonsto SIZE-S CUST-094 PROD-001 MATL-Brass SIZE-M CUST-045 PROD-001 MATL-Topaz SIZE-L CUST-075 PROD-001 MATL-Citrine SIZE-L CUST-136 PROD-001 MATL-Opal SIZE-M CUST-065 PROD-001 ATL-Moonsto SIZE-L CUST-064 PROD-001 WATL-Amethy SIZE-S CUST-091 PROD-001 ATL-Amethy SIZE-XL CUST-073 PROD-001 MATL-Jasper SIZE-XS CUST-108 PROD-001 MATL-Bronze SIZE-XL CUST-113 PROD-001 ATL-Moonsto SIZE-XS CUST-017 PROD-001 ATL-Moonsto SIZE-L CUST-038 PROD-001 WATL-Amethy SIZE-L CUST-052 PROD-001 MATL-Bronze SIZE-M CUST-018 PROD-001 TATL-Amethy SIZE-S CUST-016 PROD-001 MATL-Opal SIZE-L CUST-041 PROD-001 NATL-Sapphir SIZE-XL CUST-029 PROD-001 MATL-Jasper SIZE-XL CUST-015 PROD-001 MATL-Quartz SIZE-M CUST-139 PROD-001 ATL-Moonsto SIZE-XS CUST-085 PROD-001 MATL-Peridot SIZE-S CUST-097 PROD-001 MATL-Ruby SIZE-S CUST-016 PROD-001 MATL-Brass SIZE-S CUST-089 PROD-001 ATL-Moonsto SIZE-M CUST-141 PROD-001 MATL-Topaz SIZE-M CUST-060 PROD-001 MATL-Citrine SIZE-M CUST-148 PROD-001 ATL-Amethy SIZE-M CUST-071 PROD-001 ATL-Amethy SIZE-L CUST-048 PROD-001 MATL-Garnet SIZE-S CUST-105 PROD-001 MATL-Bronze SIZE-M Warehouse MSA-29 MSA-37 MSA-27 MSA-31 MSA-04 MSA-54 MSA-74 MSA-27 MSA-75 MSA-30 MSA-59 MSA-57 MSA-64 MSA-11 MSA-62 MSA-62 MSA-08 MSA-18 MSA-09 MSA-70 MSA-72 MSA-45 MSA-31 MSA-27 MSA-60 MSA-13 MSA-25 MSA-66 MSA-14 MSA-71 MSA-47 MSA-44 MSA-75 MSA-10 MSA-52 # Units 36 64 58 59 94 94 93 75 38 98 12 33 87 55 71 96 50 38 26 95 56 57 54 86 57 Sales 73672 481131 84568 261855 371018 183639 276760 35325 520524 219821 119763 509696 163410 454344 417522 882663 918988 202420 50736 282170 218148 229710 198864 306762 751275 253704 137648 79772 150891 769236 24490 184765 565340 706400 20988 COGS 48428 366705 45152 169235 204243 82252 168606 21686 372421 101296 76958 283183 102519 204802 321791 385665 546430 82514 24746 134907 115014 139195 102087 165148 382136 151624 103244 43971 94747 459743 14989 97085 288356 464328 10876 Collections 73672 481131 84568 261855 371018 183639 276760 35325 520524 219821 119763 509696 163410 454344 417522 882663 918988 202420 50736 282170 218148 229710 198864 306762 751275 253704 137648 79772 150891 769236 24490 184765 565340 706400 20988 21 19 29 45 86 76 29 30 31 32 33 34 35 36 31 17 93 9