"EXCEL question "

"The Company decides to reimburse Drivers that works on Plymouth. this reibursement will be a percentage of the revenue. This percentage will depend on the model of the car. Show the amount of the reimbursement in column H of Plymouth"

HZ X B D F E G H Driver Id 1 5 6 + 2 3 4 . 6 7 B 9 10 11 12 11 13 14 15 17 19 26 28 30 31 Ravenue 1809 101 99 F 28431F 474 20 F 443,92 F 62.44 F 100,13 517 66 F 24 ZTE 124 10 F 147 94 F 189637 14 15 16 Milan 66 29 273 214 301 31 80 292 33 226 248 112 34 100 366 90 27 15 257 205 313 357 261 148 151 205 178 327 158 Rever by miles 2,83 F 3,82 F 1,04F 2,22 F 1.47 F 2015 1.25 F 1.77 F 0.75 F 055 F 0,60 F 151 F 0.85 F 3.87 F 1 275 0.30 F 3.87F 1 56 F 033 F 2.21 F 108 F 1,04 F 0,54 F 1.39 F 0,42 F 0,88 F 2,64 F 121 F 2,59 F 367 21 F 464 CRF 2731F 104,59 F 23.45 F 83,55 F 45239 337 97 370 65 F 1411F 205,62 F 62.72 180,47 F 47016 895915 06:29 F Carlar 883 TM 50 5661 HV 68 130 Y 69 7326 EU 59 2580 BO 59 7125 EM 59 5183 ON 59 9163 MV 59 2848 TB 59 2050 ZM 59 4463 LX 59 7125 EM 59 9183 MV 59 4763 EP 59 3096 UR 59 2848 TB 59 4463 LX 59 1029 TU 59 2848 TB 59 1300 Y 59 4463 LX 59 2848 TB 59 4463 LX 59 4463 LX 59 4750 DG 59 4199 AO 59 5561 HV 59 5183 ON 59 2050 ZM 59 Models Volwen BMW BMW Honda BMW Vokswagen Honda Vollwagen Honda BMW Volkswagen Vokswagen Volkswagen Vokswagen Vokswagen Honda Volkswagen Citron Honda BMW Vokswagen Honda Volkswagen Volkswagen BMW Citroen BMW Honda BMW Drivet Nam Nathal TEREBBENFRANCE Constant TINOPLE EM NHE HUY Jean BONBEUR Fidel OPOSTE Anne Akce DEUSSAN James ANTOUDROL Hassan CEHEFF SEY POCYAL Gerard MANFAIMEU Mauda ERNIAZZ John DEUF Piotr INHOUVONLEICHOZ Auda JAVEL Yvon TOMBAY Sirah KASHTEY Jerome ANAITALETTRE Paco TISON Melusine EMPHALLITE Amaud BODYNOZ Tobble ORNOT TOBY Sophie FONFEC Gilles HAIPARBAL Dema PENDULALEUR Yvon ANCHIER Helmut ARDALPIK Alex KUZBIDON Ralo DUVELDYV Yves FRAIMIEUX DE LA FERMAY Kimberley TARTINN TB 19 20 21 22 23 24 25 26 27 28 29 34 38 38 39 43 44 45 148 51 52 $4 55 56 59 31 Total revenu Average revan miled Total bom 6775,32 F 1.56 F 32 33 Bonushte 12.52 Type Car Honda BMW Ronauti AU 36 37 38 39 40 12.84 305 HZ X B D F E G H Driver Id 1 5 6 + 2 3 4 . 6 7 B 9 10 11 12 11 13 14 15 17 19 26 28 30 31 Ravenue 1809 101 99 F 28431F 474 20 F 443,92 F 62.44 F 100,13 517 66 F 24 ZTE 124 10 F 147 94 F 189637 14 15 16 Milan 66 29 273 214 301 31 80 292 33 226 248 112 34 100 366 90 27 15 257 205 313 357 261 148 151 205 178 327 158 Rever by miles 2,83 F 3,82 F 1,04F 2,22 F 1.47 F 2015 1.25 F 1.77 F 0.75 F 055 F 0,60 F 151 F 0.85 F 3.87 F 1 275 0.30 F 3.87F 1 56 F 033 F 2.21 F 108 F 1,04 F 0,54 F 1.39 F 0,42 F 0,88 F 2,64 F 121 F 2,59 F 367 21 F 464 CRF 2731F 104,59 F 23.45 F 83,55 F 45239 337 97 370 65 F 1411F 205,62 F 62.72 180,47 F 47016 895915 06:29 F Carlar 883 TM 50 5661 HV 68 130 Y 69 7326 EU 59 2580 BO 59 7125 EM 59 5183 ON 59 9163 MV 59 2848 TB 59 2050 ZM 59 4463 LX 59 7125 EM 59 9183 MV 59 4763 EP 59 3096 UR 59 2848 TB 59 4463 LX 59 1029 TU 59 2848 TB 59 1300 Y 59 4463 LX 59 2848 TB 59 4463 LX 59 4463 LX 59 4750 DG 59 4199 AO 59 5561 HV 59 5183 ON 59 2050 ZM 59 Models Volwen BMW BMW Honda BMW Vokswagen Honda Vollwagen Honda BMW Volkswagen Vokswagen Volkswagen Vokswagen Vokswagen Honda Volkswagen Citron Honda BMW Vokswagen Honda Volkswagen Volkswagen BMW Citroen BMW Honda BMW Drivet Nam Nathal TEREBBENFRANCE Constant TINOPLE EM NHE HUY Jean BONBEUR Fidel OPOSTE Anne Akce DEUSSAN James ANTOUDROL Hassan CEHEFF SEY POCYAL Gerard MANFAIMEU Mauda ERNIAZZ John DEUF Piotr INHOUVONLEICHOZ Auda JAVEL Yvon TOMBAY Sirah KASHTEY Jerome ANAITALETTRE Paco TISON Melusine EMPHALLITE Amaud BODYNOZ Tobble ORNOT TOBY Sophie FONFEC Gilles HAIPARBAL Dema PENDULALEUR Yvon ANCHIER Helmut ARDALPIK Alex KUZBIDON Ralo DUVELDYV Yves FRAIMIEUX DE LA FERMAY Kimberley TARTINN TB 19 20 21 22 23 24 25 26 27 28 29 34 38 38 39 43 44 45 148 51 52 $4 55 56 59 31 Total revenu Average revan miled Total bom 6775,32 F 1.56 F 32 33 Bonushte 12.52 Type Car Honda BMW Ronauti AU 36 37 38 39 40 12.84 305