In columns G through J, use an IF formula to calculate the value of the shipping rebate for each dealer for each quarter. If you use proper cell referencing, you should be able to write a formula in cell G17 that can be copied down the column and across the row. Remember, dealers will only receive rebates in quarters where their actual quarterly sales volumes met or exceeded expected sales volumes located in cells C4:F4

G HIJ K M $ D E Manufacturer Rebates to Dealers 10 20 30 S14 $92 $80 369 464 40 Shipping Beted Annun 5141 SUE 7.40 450 Additional insti Over de volumbus OF AN Oversi volune bonit AX bertinct bonus 30 bin dos Cimity century 11 within muito 12 within Cititoare 13 4025 7,600 3.400 BSN BAN 35 NIppiy: Total Shipping Owls Volume Beinn 20 30 40 Rebate Boys Son Eine Quality Received heater Overdeler Sedans Mati 16 17 10 18 20 21 Desert 1256 3269 1710 3261 1252 Quwter Sales Wines Total 19 10 3 49 10 160 471 409 1730 147 440 430 275 1498 352 532 192 12 1790 153 173 370 LE S60 231 260 161 1150 14 530 STO 140 12 302 1100 243 41 215 441 116 150 1744 1 2 1994 12 23 112 364 400 1163 14 151 23 24 23 26 22 2 2 SI 17 VES 1 NE HE DE 16 TE ET wewe G HIJ K M $ D E Manufacturer Rebates to Dealers 10 20 30 S14 $92 $80 369 464 40 Shipping Beted Annun 5141 SUE 7.40 450 Additional insti Over de volumbus OF AN Oversi volune bonit AX bertinct bonus 30 bin dos Cimity century 11 within muito 12 within Cititoare 13 4025 7,600 3.400 BSN BAN 35 NIppiy: Total Shipping Owls Volume Beinn 20 30 40 Rebate Boys Son Eine Quality Received heater Overdeler Sedans Mati 16 17 10 18 20 21 Desert 1256 3269 1710 3261 1252 Quwter Sales Wines Total 19 10 3 49 10 160 471 409 1730 147 440 430 275 1498 352 532 192 12 1790 153 173 370 LE S60 231 260 161 1150 14 530 STO 140 12 302 1100 243 41 215 441 116 150 1744 1 2 1994 12 23 112 364 400 1163 14 151 23 24 23 26 22 2 2 SI 17 VES 1 NE HE DE 16 TE ET wewe