IF function and Vlookup.. I have done it but its giving me an error msg, please just help me fix this error.
1.In cell M4, enter a formula that uses an IF function and structured references to assign a value rating to each customer. (Hint: You will need to use an AND function in this formula.)
The IF function should check if a customer has a Tenure field value greater than 3 years AND 2016 Purchases greater than $250.
If the customer meets both those criteria, the function should return the value High.
If the customer does not meet both those criteria, the function should return the value Low. If necessary, copy the formula you created in cell M4 to the range M5:M27.
2. In cell P7, enter a formula using the VLOOKUP function to look up the Customer ID value shown in cell P4 in the Customers table (located in the range A3:M27). The VLOOKUP function should then retrieve the Discount Amount from the Customers table (the 12th column in the table) for this record. The VLOOKUP function should find an exact match to the value in P4.
Recently Asked Questions
- Consider the idea that culture and language are both dynamic and stable.Using an example from the book, your experience, or one of the suggested websites (
- Failed Technology Projects Technical projects fail when they deliver significantly late, substantially over budget, and/or with significant features missing or
- Please refer to the attachment to answer this question. This question was created from f16CCS02.pdf.