We can use the conditional formatting function (IF function) available in MS Excel for these type of problems .
This function takes different conditions provided in the formula and checks them with the concerned cells and if the answer is true a particular answer wil be shown in our worksheet (in this case "cashback") and if the answer is false another answer provided by us will be shown(in our case"coupon").
The formula mentioned below could be inserted in the formula bar and it will give the desired results in the column Promotion Type. just make sure to select the cell where you want the answer.
Hope it helped.
=IF(B2<=6,IF(C2>=4,IF(D2>150,"cashback","coupon"),"coupon"),"coupon")
can someone pls help me with this probke? Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and...
need help with 18-22 marketing questions med with francesca Je on the COUCO col grocery This Me span and no CHAPTER 35 Maring Crowng Customer and Engagement Company Caso Chick-Fil-A: Getting Better before Getting Bigger dong the food . Wh e n It Right way, Burger King and Taco Berge mong top of the C hos en bom a south Asocer lo Check Asminis to have a povinu once on who come in contact with Chick corted Chick SA Athough...
Is anyone help me this question? CASE 2-5 Coping with Corruption in Trading with Vietnam Corruption is a fact of lifie in China. In fact Transparency Interna-fo travel to cash or gifts. (This was especially true when few tional, a German organization that applies its Corruption PerceptionPRC officials had been abroad.) As a result, traders report that Index (CP) globally. rates China with a CPl of 3.6 and is number dangling foreign trips in fromt of their PRC clients has...