Traditional Culture Encyclopedia - Hotel accommodation - An EXCEL template is like this: hotel check-in, check-out, pricing. There is no hotel management software.
An EXCEL template is like this: hotel check-in, check-out, pricing. There is no hotel management software.
Total number of people 14 check-out amount 1 6 check-out amount 2 total.
20 B2 * 1 D2 * 230 C2+E2
If ((A2-B2-D2) >; =0, A2-B2-D2, "Input error, please check")
As shown above, put an equal sign in front of the formula, and then fill it down intelligently. Generally speaking, if you want to make a template, you should be more careful, such as adding judgment to the total column. If 20 people are full, you should settle the total.
- Previous article:How many times has Shanghai Disney been banned?
- Next article:Complete recommended works of glass door manufacturers
- Related articles
- Jiayu hotel
- How about Wenzhou Yan Jia Hotel?
- The hotel plays with snow
- How far is it from Guangzhou City Vocational College to Ruilong Hotel in Jianggao Town?
- Which city does Luocheng Town belong to? Where is Luocheng Town?
- How to use the recovery console function to repair the system?
- I want to write a work plan for the cashier at the hotel front desk.
- Quanzhou Wandavis Boutique Hotel Wireless Password
- What is the best fish you have ever eaten?
- After Zou Shiming retired, he was busy starting a business and hosted a banquet for guests at his hotel. How was his relationship with his wife?