Can someone please provide help with *******NUMBERS 2,4,6,8, & 11********. I'm having trouble with all of these. I keep getting them wrong

The name of cell B42 is DISCOUNT ****** need this for the answer to question 6

On the RentalData worksheet, in cell E6, enter a date formula to determine the length of rental in days. Copy this formula to the range E7:E32. 6 In cell H6, enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B42. If no discount should be applied, the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula. Copy the formula to the range H7:H32. 8 In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K7:K32. 11 On the Client Data worksheet, use Flash Fill to separate the client names in column A to the FirstName and LastName columns respectively. Mac users will need to use the Text to Columns feature. Select the range A2:A26. On the Data tab, click Text to Columns. Select Space as the Delimiter and =$B$2 as the Destination. Adjust column width of columns B and C if necessary. NO Brandon_e02cho3_grader_as_CarRental Q- Search Sheet Home Insert Page Layout Formulas Data Review View 2+ Share a Cut Autasum Calibri (Body) - 11 A A A- AT 29 to Wrap Text General Pasta B 1 4. A = Marge & Center $. % ) 00 30 Insert Delete Format Z Sort & Filter Conditional Former Formatting as Table Styles Format Clear K36 X A B C D E F G H K L M N 0 P 3 Created by Jason Easton 4 Amount of Discount Gas Option Cost of Gas Total Cost Daily Rate n n Date Rented 4/5/17 4/5/17 4/9/17 4/5/17 4/5/17 4/5/17 4/7/17 4/7/17 4/6/17 4/11/17 4/9/17 4/6/17 4/9/17 Y Y n Y n Y Auto ld 988 275 277 990 350 550 551 352 989 275 355 356 350 553 550 988 989 990 356 551 554 352 356 5 Auto Type 6 Green Collection 7 Compact/Midsize 8 Compact/Midsize 9 Green Collection 10 Fullsize/Standard 11 SUV/Minivan 12 SUV/Minivan 13 Fullsize/Standard 14 Green Collection 15 Compact/Midsize 16 Fullsize/Standard 17 Fullsize/Standard 18 Fullsize/Standard 19 SUV/Minivan 20 SUV/Minivan 21 Green Collection 22 Green Collection 23 Green Collection 24 Fullsize/Standard 25 SUV/Minivan 26 SUV/Minivan 27 Fullsize/Standard 28 Fullsize/Standard 29 Compact/Midsize 30 Compact/Midsize 31 SUV/Minivan 32 Green Collection 33 Y Date Returned/or Payment Expected Return #Days Rented Method 4/8/17 Credit Card 4/10/17 COD 4/10/17 Express Miles 4/6/17 Credit Card 4/8/17 Credit Card 4/9/17 Rewards 4/10/17 Credit Card 4/9/17 Credit Card 4/9/17 Credit Card 4/18/17 COD 4/16/17 Credit Card 4/8/17 Credit Card 4/13/17 Rewards 4/14/17 Express Miles 4/17/17 COD 4/15/17 Credit Card 4/16/17 Express Miles 4/10/17 Credit Card 4/10/17 Rewards 4/15/17 Express Miles 4/9/17 Express Miles 4/11/17 Credit Card 4/17/17 Express Miles 4/14/17 Credit Card 4/15/17 Rewards 4/12/17 COD 4/18/17 Express Miles Y Y 4/8/17 Y n n Y 4/11/17 4/9/17 4/10/17 4/7/17 4/9/17 4/11/17 4/7/17 4/10/17 4/11/17 4/11/17 4/11/17 4/10/17 4/11/17 Y Y Y n n 276 277 554 990 Y RentalData ClientData + Ready + 132% NO Brandon_e02cho3_grader_as_CarRental Q- Search Sheet Home Insert Page Layout Formulas Data Review View 2+ Share a Cut Autasum Calibri (Body) - 11 A A A- AT Eto Wrap Text General Copy Pasta B 1 A = Merge Center $. % ) 00 30 Insert Delete Format Z Sort & Filter Conditional Format Formatting as Table Format Styles Clear K36 X B C D D E F H 1 K L M N 0 Y Y Y 4/7/17 4/10/17 4/11/17 4/11/17 4/11/17 4/10/17 4/11/17 4/9/17 4/11/17 4/17/17 4/14/17 4/15/17 4/12/17 4/18/17 Express Miles Credit Card Express Miles Credit Card Rewards COD Express Miles n n Y 26 SUV/Minivan 554 27 Fullsize/Standard 352 28 Fullsize/Standard 356 29 Compact/Midsize 276 30 Compact/Midsize 277 31 SUV/Minivan 554 32 Green Collection 990 33 34 35 36 Rental Rates 37 Green Collection $49.99 38 Compact/Midsize $76.49 39 Fullsize/Standard $84.99 40 SUV/Minivan $104.99 41 Discount for Express Miles 42 or Rewards 20% 43 44 Cost to Fill Tank $65.00 45 46 Median Rental Length 47 Number of Rentals 48 49 50 51 52 53 54 55 56 57 RentalData Client Data + Ready + 132%