What Excel formula would I have to use to fill out the green cells with given information

In the green cells use formula(s) to determine each sales person's commissions. W NP D . 4 Commissions 'ProductLine1: Straight Dollar ProductLine2: Commission Commission Rate x Sales Product1 $100.00 Products 0.02 Product2 $150.00 ||Producto 0.03 Product3 $125.00 Product7 0.025 Product4 $110.00 ||Products 0.0275 10 11 12 13 14 Date Sales Product Product Line 11/11/19| $3,214.21 Product ProductLine1 11/11/19 $2,839.58 Product ProductLine1 11/11/19 $4,080.47 Product ProductLine1 11/11/19 $4,393.67 Product ProductLine2 11/11/19] $4,479.60 Products ProductLine2 11/11/19 $2,654.98 Products ProductLine2 11/11/19| $3,994.22 Product ProductLine2 11/11/19| $4,098.80 Product2 ProductLine1 11/11/19 $4,734.34 Product ProductLine2 11/11/19 $3,493.10 Product1 ProductLine1 11/11/19 $3,284.31 Product2 ProductLine1 11/11/19| $4,766.40 Product ProductLine2 11/11/19 $3,601.61 Product ProductLine1 11/11/19| $4,272.68 Product ProductLine2 11/11/191 $2,142.69 Product ProductLine1 11/11/19| $4,389.33 Product ProductLine2 11/11/19 $3,876.18 Product4 ProductLine1 11/11/19 $3,907.71 Product2 ProductLine1 11/11/191 $4,150.70 Product ProductLine1 11/11/19| $2,773.03 Product ProductLine2 11/11/19 $2,145.51 Product ProductLine2 Sales Person Jan Jelinek Richard D. James Tim Hecker | Christian Fennesz Brian Eno Ryuichi Sakamoto Kieran Hebden Michael Sandison Marcus Eoin Sean Booth Rob Brown Markus Popp Jan St. Werner Edgar Froese Klaus Schulze Peter Baumann Christopher Franke Michael Hoenig Manuel Gottsching Laurel Halo James Holden 15 16 17 18 19 20 21 22 23 24 25 26