The Daily Charge is determined by using the Room Number and Rate Code to look up the value in the DailyChg worksheet. Use the XLOOKUP() function with a nested XLOOKUP() function to find the correct daily charge and display it in column I of the Reservation worksheet.

• Use the IFS function to determine the seating surcharge (column K) based upon the value in column H. The seating codes are CI, CL, LE, and US. The CI seating style costs an additional $50, CL is the standard – for which there are no additional charges, LE is an upcharge of $125, and the US costs an additional $200. Don’t hardcode the values in the function, but rather, create an input area on the DailyChg worksheet.

• Calculate the Reservation’s Total Charges using the formula of Daily Charge * Booked days + Seating Surcharge.

  

1 2 3 4 5 6 7 8 9 10 11 12 B A Room# Meeting Room AL Alabama AU Auditorium BD Boardroom CA California CF Conference Center CO Colorado FL Florida GA Georgia D Megan Davis Convention Center Daily Meeting Room Rates AD ST $450.00 $600.00 $918.75 $1,225.00 $412.50 $550.00 $487.50 $650.00 $975.00 $1,500.00 $468.75 $625.00 $450.00 $600.00 $431.25 $575.00 E SP $390.00 $735.00 $330.00 $422.50 $900.00 $375.00 $390.00 $431.25