In H14: 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 assembly plant is Toyota City insert the MSRP, otherwise the cell should be blank. Copy the function down to the other cells in the column.

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

total provided rows (entries) in the excel sheet for the question is 413

D 1 O www EE WAL Verslete Loya Tec ww BO Wodely 11 2011 MA TC ITY MO Whaber CC Eine DO Color BOOGE FOR no Dulce TO Assembly Try Cat Cher your shot A2 TRETUN TDOO Sie 2013 ER JU MA FICE ME 20 HOME 2 3 4 5 . 7 8 . 10 11 12 MSRP VIN code 14 TCOOL 1 Soles Price 25.4 28 OCCITAS Yew fold Dealer Sales Rep 2013 1 304 2011 V2 2011 2010 M AT 25 2770 25.01 0487 WH WA VOX RECIATE 04 WI We AM 2 TCENON FYROM ( 904 14 2011 1412 ON 20 BE BAGAI HOLOGIA 30 TA PUS 27 w BE WE THE a 0 10 103 2171 20 75 21 I TYR WHO 29 TVIRTIN 30 W.123 SHOWSHION Chet NE TI VI TI VI 2011 2011 3091 104 9464 1912 10 Partly ENG 1727 23.11.20 D 1 O www EE WAL Verslete Loya Tec ww BO Wodely 11 2011 MA TC ITY MO Whaber CC Eine DO Color BOOGE FOR no Dulce TO Assembly Try Cat Cher your shot A2 TRETUN TDOO Sie 2013 ER JU MA FICE ME 20 HOME 2 3 4 5 . 7 8 . 10 11 12 MSRP VIN code 14 TCOOL 1 Soles Price 25.4 28 OCCITAS Yew fold Dealer Sales Rep 2013 1 304 2011 V2 2011 2010 M AT 25 2770 25.01 0487 WH WA VOX RECIATE 04 WI We AM 2 TCENON FYROM ( 904 14 2011 1412 ON 20 BE BAGAI HOLOGIA 30 TA PUS 27 w BE WE THE a 0 10 103 2171 20 75 21 I TYR WHO 29 TVIRTIN 30 W.123 SHOWSHION Chet NE TI VI TI VI 2011 2011 3091 104 9464 1912 10 Partly ENG 1727 23.11.20