Ravi Sir's Cards › Excel
Hotel Management System in Excel (card 1 of 2)
Revision card 1 for Hotel Management System in Excel: Nights: =H5-G5 gives 2; GST rate by tariff per night: =IF(F5<=Setup!$B$5,Setup!$B$6,Setup!$B$7) gives 5%; GST amount: =ROUND(J5*K5,2) gives ₹280.00.
Read card text
What this card says
1 for Hotel Management System in Excel: Nights: =H5-G5 gives 2
GST rate by tariff per night: =IF(F5<=Setup!$B$5,Setup!$B$6,Setup!$B$7) gives 5%
GST amount: =ROUND(J5*K5,2) gives ₹280.00.
Learn this in the lesson: Hotel Management System in Excel: Room Bookings, Daily Occupancy, ADR, RevPAR, GST Room Bill and Dashboard