Tents do not come in the size your arithmetic produces. They come in 20-foot sections, so the useful answer is not “1,800 square feet” but “a 20x100, because that is what is on the truck.” Rounding up to the module is the whole job.
150 guests at a seated dinner need 1,800 sq ft, which becomes five 20x20 sections — 2,000 sq ft of tent.
The example
Three event styles, each with a guest count, the square feet that style needs per guest, and the section size the tent is built from.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Style | Guests | Sq ft/guest | Section sq ft | Tent sq ft |
| 2 | Cocktail standing | 120 | 6 | 400 | 800 |
| 3 | Seated dinner | 150 | 12 | 400 | 2000 |
| 4 | Buffet plus dance | 200 | 15 | 400 | 3200 |
The formula
Round the section count up, then turn sections back into square feet:
How it works
Four steps and one rule of thumb per style:
B2*C2is raw square footage. Standing cocktail runs 5–6 sq ft a guest, seated dinner at rounds 12, and 15 once you add a buffet line and a dance floor./D2converts to sections. A 20x20 frame is 400 sq ft — the unit most rental fleets are built around.ROUNDUP(...,0)takes the next whole section, because half a tent does not exist.*D2multiplies back to square feet so the answer is in the same unit the customer asked about.
Divide the result by the tent width to name it: 2,000 sq ft at 20 feet wide is a 20x100. Now it is an item on a contract.
Try it: interactive demo
Enter guests, square feet per guest for the style, and your section size.
Variations
Name the tent
Divide by the width to get the length of a 20-foot-wide frame tent.
Add a catering tent
Append a fixed back-of-house allowance before rounding.
Pitfalls & errors
Square feet per guest is not a constant — it is the single biggest lever in the formula. Quoting a seated dinner off a cocktail-hour figure will put a tent on site that is half the size the event needs.
A dance floor, a band, a bar and a gift table are not guests but they occupy tent. Either raise the per-guest figure or add their footprint as a flat number, as in the variation above.
Do not round the section count with ROUND. At 4.4 sections it hands back four, and the tent arrives 400 square feet short of the seating chart.
Practice workbook
Frequently asked questions
What square footage per guest should I use?
Why round to sections instead of just quoting square feet?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class