please give me the formulas needed to fill put these questions

946 285 898 363 988 89 937 295 225 986 22 23 24 2) Create a function that displays 25 1 if the dealership is Taylor 26 27 Motors; display a value of 2 if the 28 dealership is Don Wood. 29 Everything else should be 30 assigned a value of 3. 31 32 33 34 3) If a car's price is $10,000 or 35 less AND it is automatic, then it 36 should be coded as "Yes". If not, 37 then have Excel display a "-". 38 39 40 41 4) If a car's price is $7,000 or less 42 OR if the mileage is less than or 43 equal to 50,000 miles, then it 44 should be coded as "Yes". If not, 45 then have Excel display a "-". 14 963 469 326 711 876 38 311 823 388 353 864 890 854