Last answered:

05 Jan 2022

Posted on:

04 Jan 2022

0

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

image.png

3 answers ( 0 marked as helpful)
Posted on:

04 Jan 2022

0

Hi Asmaa,
Can you please share a screenshot with your solution? Thanks!

Posted on:

04 Jan 2022

0

I use a Russian MS office,
image.png

Posted on:

05 Jan 2022

0

Hi Asmaa,
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!
Best,
Ned

Submit an answer