House arrows get lost, bent and broken. Multiplying shooters by arrows per shooter gives total arrows shot, applying the loss rate estimates the casualties, and ROUNDUP returns a whole number you can price for replacement.
A Saturday with 80 shooters, 24 arrows each and a 1.5% loss rate loses 29 arrows, costing $174.00 to replace.
The example
Three worked examples. Change any yellow input in the practice workbook and the results recalculate.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Case | Shooters | Arrows each | Loss rate | Arrow cost | Arrows lost | Replacement |
| 2 | Weeknight | 30 | 24 | 1.5% | $6.00 | 11 | $66.00 |
| 3 | Saturday | 80 | 24 | 1.5% | $6.00 | 29 | $174.00 |
| 4 | League | 50 | 36 | 1.2% | $7.50 | 22 | $165.00 |
The formula
Here is the formula, built directly from the inputs:
How it works
Here is the logic, one piece at a time:
B2*C2is the total arrows shot.*D2applies the loss rate.ROUNDUP(...,0)returns whole arrows.F2*E2prices the replacements.
Keep every number in its own input cell so the formula never needs editing.
Try it: interactive demo
Enter the values below.
Variations
Per shooter cost
Replacement cost per shooter.
Annual
Fifty-two similar nights.
Pitfalls & errors
Loss rates vary with target type and backstop; track yours.
Enter the loss rate as 1.5% or 0.015.
Charge a small lane fee that covers replacement.
Practice workbook
Frequently asked questions
Why round up?
Does it apply to firearms ranges?
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