steps 11&12
Enter a formula in cell K5 of the Reseryation_Analysis sheet that displays the correct room rate. Use a VLOOKUP function and an INDIRECT function to do this. The room rate depends on both the Building and the Reom.Tyne. (Room rates are listed on the Rates\&Fees sheet.) Copy the formula in cell K5 down the column to K36. Hint: Room rates for each different building listed on the Rates\&Fees sheet have been named. Enter a formula in cell L5 of the Reseryation. Analysis sheet that calculates the discount for cach transaction. Use the LET function, AND functions and an IFS function to do this. Rewards members automatically receive a percentage discount off the room rate. The pereentage can be found in cell D2 of the Rater\&Feer sheet. Customers who have a coupon (text in cell is "Yes") reccive a percentage discount off the room rate. The percentage can be found in cell E2 of the Rater\&kess sheet. Use the IPS function to multiply the correct percentage discount times the Room. Rate. If the customer is not a rewards member and does not have a coupon, then he/she does not receive any discount. (Hint: AND functions return a True or a Ealse. The logical tests in the IFS function should evaluate whether the above names cqual True.) Cogy the formula in cell L.5 to cell mango L6:L36. onvention Center. Enter a formula in cell K5 of the Reseryation_Analysis sheet that displays the correct room rate. Use a VLOOKUP function and an INDIRECT function to do this. The room rate depends on both the Building and the Reom.Tyne. (Room rates are listed on the Rates\&Fees sheet.) Copy the formula in cell K5 down the column to K36. Hint: Room rates for each different building listed on the Rates\&Fees sheet have been named. Enter a formula in cell L5 of the Reseryation. Analysis sheet that calculates the discount for cach transaction. Use the LET function, AND functions and an IFS function to do this. Rewards members automatically receive a percentage discount off the room rate. The pereentage can be found in cell D2 of the Rater\&Feer sheet. Customers who have a coupon (text in cell is "Yes") reccive a percentage discount off the room rate. The percentage can be found in cell E2 of the Rater\&kess sheet. Use the IPS function to multiply the correct percentage discount times the Room. Rate. If the customer is not a rewards member and does not have a coupon, then he/she does not receive any discount. (Hint: AND functions return a True or a Ealse. The logical tests in the IFS function should evaluate whether the above names cqual True.) Cogy the formula in cell L.5 to cell mango L6:L36. onvention Center
