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.