Practice practicing hotel expense index in Excel

The following article gives detailed instructions for you to practice on how to calculate the values ​​in the hotel cost list in Excel 2013.

The example has the following data table:

Practice practicing hotel expense index in Excel Picture 1

Calculate the amount the tenant will pay at the current dollar rate.

To calculate the amount the tenant must pay: The number of tenants, the type of room the tenant uses to calculate the unit price, the number of holidays and the unit price on a single day the tenant.

Step 1: Calculate the number of tenants the week -> Enter the formula: = INT ((F5-E5) / 7) -> press Enter the number of tenants the week is:

Practice practicing hotel expense index in Excel Picture 2

Step 2: Similarly copy the remaining values ​​to result:

Practice practicing hotel expense index in Excel Picture 3

Step 3: Calculate weekly unit prices based on the notes below -> enter the formula: = IF (D5 = "A", $ F $ 13, IF (D5 = "B", $ F $ 14, IF (D5 = "C", $ F $ 15, IF (D5 = "D", $ F $ 16, $ F $ 17))))

Practice practicing hotel expense index in Excel Picture 4

Step 4: Press Enter -> weekly unit price and room type are:

Practice practicing hotel expense index in Excel Picture 5

Step 5: Similarly copying the formula to the remaining values ​​results:

Practice practicing hotel expense index in Excel Picture 6

Step 6: To calculate the number of holidays enter the formula: = MOD (F5-E5,7) press Enter -> number of holidays is:

Practice practicing hotel expense index in Excel Picture 7

Similarly copy for the remaining values.

Step 7: Calculate daily price based on room type -> enter the formula: = IF (D5 = "A", $ H $ 13, IF (D5 = "B", $ H $ 14, IF (D5 = "C" , $ H $ 15, IF (D5 = "D", $ H $ 16, $ H $ 17))))

Practice practicing hotel expense index in Excel Picture 8

Step 8: Press Enter and make a copy for the remaining values:

Practice practicing hotel expense index in Excel Picture 9

Step 9: Calculate the total amount payable by the customer -> enter the formula: = MIN (H5, ((I5 * J5) + (G5 * H5))) * $ F $ 12 -> press Enter -> total payment was:

Practice practicing hotel expense index in Excel Picture 10

Step 10: Similarly copying the formula to the remaining values ​​results:

Practice practicing hotel expense index in Excel Picture 11

The above is a detailed guide on how to declare hotel microcomputer rent in Excel 2013.

Good luck!