In I14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the vehicle model year is 2016 insert the MSRP, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell I13 use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

A14 A X fx fx TC13G123JP D A B E F G G H | J K L M S T U v W Y Z AA VIN # code AABBCCDDEE Enter your name in cell A1 1 2 3 4 5 6 7 TC TY VG VJ Vehicle type Toyota Corolla Toyota Camry VW Golf VW Jetta NO Q R Vehicle Information Number (VIN) Breakdown CC Engine DD Colour G1 Gas 1800 CC 20 Red G2 Gas 2500 CC 21 Metallic Red D2 Diesel 2000 CC 23 Metallic White 24 Blue 25 Metallic Blue BB Model year 11 2011 12 2012 13 2013 14 2014 15 2015 16 2016 EE Assembly Plant JP Toyota City ON Cambridge GR Dusseldorf MX Puebla Dealer Name T1 Western Toyota T2 Highland Toyota V1 City Volkswagen V2 Northern Volkswagen Enter your student # in cell A2 22 White Sales Rep Name 501 Mark 502 Susan 503 Wassim EA 504 Lee 910 Rashid 911 Ming 912 John 913 Allison 8 1 2 3 4 5 6 7 8 9 10 11 12 9 10 11 12 13 VIN # code 14 TC13G123JP 15 VJ13G224MX 16 VJ15D224MX 17 VG146225GR 18 VG 16D221MX 19 TY13G123JP www 20 VJ14G221MX w 21 TC13G2210N 22 TY14G2250N 23 TY15G2220N . 24 TY14G2210N 25 TC16G2220N 26 TC12G 120JP 27 TY16G 125JP 28 VJ110224MX 20 TV 44000 29 TY11G2210N a 3224GB 30 VG13D224GR TRAEC4940N 31 TC15G 1210N variano 32 TY12G 1200N 20 M4409921 33 VG11G223MX 24 HADDAD 34 VJ14G224GR 35 VJ11D220GR 2 V 116C 225MY 36 VJ16G225MX 27 TV44700D 37 TY11G220JP 20 V AC224MY 38 VJ14G221MX 20 TV4412017 39 TY11G120JP An TC48C2220N 40 TC13G2220N 41 TC13G 124JP 42 TY14G 122JP 43 VG 14D 220GR 44 VG 16D225GR Year Sold Dealer Sales Rep 2013 T1 504 2014 V2 913 2014 V2 913 2014 V2 913 2015 V1 913 2012 T1 501 2014 V2 910 2013 T1 504 2015 T2 504 --- 2014 T2 503 --- 2015 T1 504 - 2017 T2 502 --- 2012 T2 504 2015 T1 503 2010 V1 910 2049 TA EA 2011 T1 504 2040 2013 040 V1 910 2045 2016 TO 12 504 2049 2011 TA Eng T1 501 2045 2012 040 V1 913 2044 2014 044 V2 911 2049 2011 040 V1 910 2045 2016 V2 910 2040 2010 ED 12 503 2044 2014 V2 910 2010 ED 12 502 2012 TO 2013 12 501 2012 T1 11 502 502 2015 T2 501 2015 V1 910 2016 V1 913 MSRP 18,776 25,067 27,76 22,761 25,311 25,058 25,190 20,452 27,477 27,841 27,632 21,044 18,695 25,812 25 812 28 29 26,881 26,743 26 748 24 FEA 24,554 40045 19,212 257 24,857 22447 22,117 26 211 25,244 cz 26,775 25,690 25. 28 877 26,877 25,305 25 205 wsze 24,575 20649 20,513 18,758 18 758 25,244 24,752 25,307 Sales Price 18,837 25,021 30,467 25,036 22,682 22,559 25,208 w 16,417 22,013 22,323 22,090 23,185 15,077 25.775 25,775 24.124 21,431 0 0 26,932 19,826 404 19,172 24,781 2015 22,200 2297 20,237 26,821 28,239 20 290 con 26,920 25,327 70484 22,161 2014 20,551 18,893 22,827 19,971 22,750