1. Write a set of Excel functions in cell Orders!H2, which can be copied down the column to cell H14, to determine thewarranty cost of the computer based on the warranty type (if chosen) and the cost of the computer. If the product number does not exist in the inventory, display a 0 in the cell (this will be a '-' in accounting format). (Use the named range Warranty in your formula.) Note: If the customer chooses to purchase a warranty, they can only select one of the options. (Hint: Use the IFERROR(HLOOKUP()) functions here and an embedded IF to find which row to return (2 or 3)for the warranty type).

=IFERROR(HLOOKUP(lookup value for the computer cost in column G of the Orders worksheet, table array in Warranty Types worksheet for warranty information named Warranty, IF(is it an extended 3 year warranty only?, return row 2, IF(is if it is an extended 3 year warranty and accidental damage or theft?, return row 3, return 0)), TRUE), 0)

=IFERROR(HLOOKUP(G2,Warranty,IF(_________,2,IF(_________,3,0)),TRUE),0)

H2 XV fav =IFERROR (HLOOKUP (G2, Warranty, IF("3 Year Warranty Only", 2, IF("3 Year & Accidental", 3,0) ) , TRUE), 0) A B C D E F G H Product 3 Year 3 Year & Computer |Warranty Total 1 Customer Name Number Product Warranty Only | Accidental Cost Cost Cost 2 James Brown 1082 HP Pavilion TRUE FALSE $ 1,049 un B General Mccarthy 7153 Acer Ultrabook FALSE TRUE $ 1,027 4 Michael Jordon 5252 Acer Aspire FALSE FALSE 594 5 Richard Chamberlain 4856 Dell Alienware FALSE TRUE $ 3,022 6 Jim Reed 2236 INVALID TRUE FALSE INVALID 7 James Monroe 4856 Dell Alienware TRUE FALSE $ 3,022 8 Lady Bird 4135 Mac book FALSE FALSE S 4,019 9 Josh Broden 5514 Dell XPS FALSE TRUE $ 2,075 10 George Lucas 6546 HP Gaming FALSE TRUE $ 2,994 11 Bradley Cooper 7854 Apple MacBook TRUE FALSE S 4,321 12 Charlie Brown 7854 Apple MacBook FALSE FALSE S 4,321 13 Dennis Rodman 5252 Acer Aspire FALSE FALSE 594 14 Jonathon Winters 8032 Gateway 71B FALSE TRUE 500 S 15 16 17 18 > Orders Inventory Warranty Types + Ready Accessibility: Good to go Display Settings