Help me with the formulas of 6-9.

4. Determine the average mileage in cell B43 for vehicles that fulfil the two conditions in range A41:B42! If cell B41 or B42 is edited, the answer should be updated automatically! If there is no vehicle that meets the two conditions, display "NONE" instead! (4 points) 5. In cell B46 display the consumption of the vehicle whose identifier is in cell A46! The connection between the cylinder capacity and the consumption can be found in auxiliary table 01:P5 which contains lower limits. However, if the given identifier cannot be found in the main table, show message "WRONG IDENTIFIER"! (3 points) 6. Set italic font style and lightgreen background color for whole rows in which the cylinder capacity is below 2000 cm3 and the year of manufacture is greater than 2009! Format by using your own formula! (3 points) 7. In cell A48 show the identifier of the oldest vehicle! However, if there are more vehicles with the lowest year of manufacture, display "MORE"! (4 points) 8. In cell A50 determine the maximum year of manufacture of the vehicles that meet ANY of the following conditions: (1) the cylinder capacity is between 1000 and 2000 (including the limits), (2) the mileage is higher than the average. If there is no proper vehicle, show "NONE" instead! (5 points) 9. In cell A57 calculate the average mileage of vehicles that meet BOTH of the following conditions: (1) the year of manufacture was before 2008 or after 2010 (excluding these two dates) (2) the cylinder capacity is NOT higher than the average cylinder capacity of the vehicles manufactured in 2011. (5 points)