question regarding the final exam
I run the solution function but the result was zero, I believe we suppose to choose the cell y1 where the 'affiliation' text is located...I'm still confused about the function used..Any explanation, please
Great to hear from you. Thanks for the clarification. In this case, the formula that we used was supposed to be applied to the cells in columns X and Y under affiliate. If you use the formula in the solution, it would allow you to fill in EVERGREENSALE20 sales from ads and affiliate and PROMO15 sales from ads and affiliate. Hope this helps!