Question: What is the answer for the following excel question? QUESTION 4 This worksheet was used to find inconsistencies in the data. For column I (cell
What is the answer for the following excel question?

QUESTION 4 This worksheet was used to find inconsistencies in the data. For column I (cell 113), what formula would be used to get the result showrn 1 Order Date ? ltem NoQTY . Unit Price ? Total Amount . Supplier No Supplier Name 202/03/2016 INS 3 03/15/2017 IN4 4 06/20/2016 INS 5 02/07/2016 IN6 6 04/08/2016 IN6 7 10/09/2016 IN11 Calculated Amount Error 41.00 $25.00 50.00 $11.00 $11.00 $29.00 41.00 41.00 $17.00 15.00 $29.00 $50.00 $22.00 41.00 SO-7800 175.00 SO-783 300.00 SO-788 $66.00 SO-785 $66.00 s0-785 145.00 SO-794 41.00 SO-784 41.00 SO-784 51.00 SO-790 15.00 SO-778 $87.00 SO-794 300.00 SO-788 $66.00 SO-797 41.00 $175.00 $300.00 $66.00 $66.00 $145.00 41.00 $41.00 51.00 $15.00 $87.00 N/A 12/10/2016 INS 901/20/2017 INS 0 11/19/2016 IN10 102/04/2016 IN 12 07/06/2016 IN11 3 01/29/2016 IN 14 04/17/2016 IN13 Sem LLP Tristique Neque Venenatis Ltd Quis Tristique Ac Corporation Quis Tristique Ac Corporation Donec Corporation Magna Praesent Interdum PC Magna Praesent Interdum P Erat LLP Libero At Auctor Industries Donec Corporation Tristique Neque Venenatis Ltd Eu Neque LLP 150.00 ERROR $66.00 -IF(E13>H13,"ERROR","") VLOOKUP(113,Supplier_Table,2,"Error'") IF(E13 H13,"ERROR","") VLOOKUP(I13,Error_Table,2,0)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
