I NEED HELP WITH QUESTIONS 12-17. I don't understand How to set up the formulas. I will upvote and promote it! Problems are attached and Esxxcel Spreadsheets show What information needed to answer questions. THANK YOU SO MUCH!

Enter a formula m cell L5 of the Reservation Analysis sheet thet calculates tise discoumt for ench transaction. Use the L.ET fienction, AND fiunctions and am IFS fimetson to do this Rowarda members antomatically rocoive a perocntage diacount off the room rate. The percentage can be found in cel D2 of the Kateserees absec. Custoncers tho have a conpon (text in cell is "Yes") receive a percentage discount off the rocm rate. The percentage cant be found in cell EZ of the Rates\& Fees sheet. Detine the following names in the IET function: 3 Enter a formula m cell L5 of the Reservation Analysis sheet thet calculates tise discoumt for ench transaction. Use the L.ET fienction, AND fiunctions and am IFS fimetson to do this Rowarda members antomatically rocoive a perocntage diacount off the room rate. The percentage can be found in cel D2 of the Kateserees absec. Custoncers tho have a conpon (text in cell is "Yes") receive a percentage discount off the rocm rate. The percentage cant be found in cell EZ of the Rates\& Fees sheet. Detine the following names in the IET function: 3