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
- Hello I am trying to figure out the correct ERD cardinality for this diagram. I am not sure how to go about selecting the correct Crows foot
- What is measured by the denominator bottom of the z-score test statistic ?
- Even if a treatment has no real effect it is still possible to obtain an extreme sample mean that is very different from the population mean . What outcome is