What is the answer for the following excel question? QUESTION 4 This worksheet w

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 113), what formula would be used to get the result showrn 1 Order Date ? ltem No·QTY . 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)

Explanation / Answer

IF statement syntax in excel :

IF(condition,"If condition is true, do this","else do this")

=IF(E13<>H13, "ERROR","")

This statement means if E13 is not equal to H13 ,print ERROR else print nothing in cell I13.

Note: <> means not equal to

Value of E13 = $300.00

Value of H13 = $150.00

As these values are not equal therefore condition <> becomes true and "ERROR" is printed in cell (I13).

Therefore, correct choice is =IF(E13<>H13, "ERROR","")

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.