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!

4.3 ★ | 3 Vote

May be interested

  • Basic errors to avoid when doing gymBasic errors to avoid when doing gym
    everyone knows the benefits of the gym, but not everyone knows how to practice correctly even with basic movements. actions such as pushing, squatting, lifting weights, sagging, ... seem simple but very easy to make mistakes while practicing.
  • Index function in ExcelIndex function in Excel
    the index function is a function that can refer to any cell on an excel worksheet, it is combined with many other functions and brings a significant effect.
  • Instructions for practicing fast keyboard typing, effective 10-finger typingInstructions for practicing fast keyboard typing, effective 10-finger typing
    practicing fast keyboard typing helps you enter data accurately, save time and improve work efficiency. if you have not improved your typing speed despite practicing for a long time, you may not have applied the right method. let's explore how to practice typing effectively through this article.
  • Use Index in Access 2016Use Index in Access 2016
    an index is a pointer to each value that appears in the indexed table / column, which has the same meaning as the entries in the index of a book.
  • Guidelines for importing Chemistry formulas in ExcelGuidelines for importing Chemistry formulas in Excel
    entering chemistry formulas in excel spreadsheets helps us to handle formulas more easily, especially for those who often have to work with chemistry or with math when they have the above index, the index below.
  • Look up data in Excel tables: Replace VLOOKUP with INDEX and MATCHLook up data in Excel tables: Replace VLOOKUP with INDEX and MATCH
    quick lookup of data in excel tables: replace vlookup with index and match. do you know yet? let's tipsmake.com find out in the article below!
  • Tux Typing - Free typing practice tool for kidsTux Typing - Free typing practice tool for kids
    tux typing is one of the 10-finger typing practice programs, testing your computer speed after practicing and mastering 10-finger typing.
  • How to Connect a PS4 to Hotel WiFiHow to Connect a PS4 to Hotel WiFi
    there is nothing better than playing online games to forget the boredom of having to stay in a hotel room. however, if you want to connect your ps4 to your hotel's wi-fi but forget to bring your personal hotspot, you may have some problems with the hotel's network security. this article gives you a few simple ways to connect your ps4 to your hotel's network using a wired or wireless connection. if you're still having problems connecting your ps4 to your hotel's wi-fi, scroll down to the bottom of this post to learn how to use a custom server that helps you bypass hotel network security.
  • Index and Match functions in ExcelIndex and Match functions in Excel
    the following article gives detailed instructions on how to use the index and match functions in excel. use these functions to help you find the exact value on any column and row.
  • Instructions for creating superscript, subscript in ExcelInstructions for creating superscript, subscript in Excel
    the article i will guide you to write the superscript and subscript in excel.