In cell K4, enter a formula that uses an IF function and structured references t

Question

In cell K4, enter a formula that uses an IF function and structured references to determine customer discount eligibility. (Hint: You will need to use the OR function in this formula.)

A customer is eligible for a discount if the value in a customer’s 2016 Purchases is greater than or equal to $250 OR if the customer’s First Order was placed before 2012.

If the customer qualifies for a discount, return a value of Y. (Hint: For the value_if_true value, use “Y”.)

If the customer does not qualify for a discount, return a value of N. (Hint: For the value_if_false, use “N”.) If necessary, copy the formula you created in cell K4 to the range K5:K27.

Explanation / Answer

It would have been better if you have also provided the table sructure or table column headers.

Still let me assume the column names, and provide you the following formula

= IF(OR([@[2016_Purchases]]>=250, [@[First_Order]]<2012), "Y", "N")

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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