Question

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

Answer 1

The answer is written on Formula Bar. Please refer that.. also note only for your reference selected data has been picked for illustration purpose

Con = Book1 - Microsoft Excel - 9 X Page Layout Formulas Data Review View Home Insert * Cut La Copy Paste Format Painter Clipboard 19 D *- } Autosum A7 D Calibri - 11 - A A = = = D Wrap Text General Fill- * BI U PA Merge & Center Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles 2 Clear Filter Select Font Alignment Number Styles Cells Editing fax =IF(C5=$G$4,$H$4,IF(C5=$G$5,$H$5,IF(C5=$G$6,$H$6,IF(C5=$G$7,$H$7,IF(C5=$1$4,B5*$J$4,IF(C5=$1$5,B5*$J$5,IF(C5=$1$6,85*$J$6,IF(C5=$1$7,65*$J$7)))))))) C D E KL M N O F5 A B P Q 1 3 0.02 125 4 date sales 5 11/11/2019 6 11/11/2019 7 11/11/2019 8 11/11/2019 9 11/11/2019 10 11/11/2019 0025 productline1 productline2 straight commission rate x sales commission product1 100 products product2 150 producto 0.03 product3 125 product7 product4 110 products 0.0275 product product line sales person commissions 3214.21 product productline1 2839.58 products productline1 125 4080.47 product4 productline1 110 4393.67 products productline2 87.8734 4479.6 products productline3 123.189 2654.98 products productline2 53.0996 Sheet1 Sheet2 Sheet3 Activate Windows Go to Settings to activate Windows 20 100% - - u 1:19 PM AD 4X ENG : 11/12/2019 Ready E