Charter Fishing: Boat Limit For The Trip

All versions

Two regulations run at once on a charter: what each angler may keep and what the vessel may keep. The number that binds is whichever is smaller, and getting it wrong is not a rounding error — it is a citation at the dock.

Quick formula: The lower of the two ceilings:

=MIN(B2*C2,D2)

Six anglers at two fish each is twelve, but a ten-fish vessel limit means the boat keeps ten.

Functions used (tap for the full reference guide):

MIN PRODUCT

The example

Three trips on the same boat, each with a different headcount and a different species rule in play.

	A	B	C	D	E
1	Trip	Anglers	Per angler	Vessel limit	Boat keeps
2	Snapper AM	6	2	10	10
3	Snapper PM	4	2	10	8
4	Grouper full day	12	3	25	25

The formula

One multiplication inside one MIN:

=MIN(B2*C2,D2) // angler limit total vs vessel limit — the smaller one binds

How it works

Read it as two rules competing:

B2*C2 is the angler-side ceiling: paying passengers times the per-person bag limit for the species.
D2 is the vessel-side ceiling, which some fisheries impose regardless of how many people are aboard.
MIN(...) picks whichever rule binds first. On a busy boat that is usually the vessel limit; on a light charter it is the angler count.
Crew do not count as anglers unless the regulation for that fishery says they do — and in several fisheries it explicitly says they do not.

Build one row per species you are targeting that day. A trip that switches from snapper to grouper is two rows with two different answers, not one blended number.

Try it: interactive demo

Interactive

Enter the headcount, the per-angler limit, and the vessel limit for the species.

Anglers

Per-angler limit

Vessel limit

Variations

Fish still available

Subtract what is already in the box to give the mate a live remaining count.

=MIN(B2*C2,D2)-F2

Flag which rule binds

Say it in words so the deck does not have to interpret a number.

=IF(B2*C2<=D2,"Angler limit","Vessel limit")

Pitfalls & errors

Limits change by season, by zone, and sometimes mid-season by emergency rule. Keep the per-angler and vessel columns as inputs you update from the current regulation, never as constants inside the formula.

Add a size-limit column next to this one. A boat can be well under its numeric limit and still be non-compliant on a single short fish.

Do not include the captain and mate in the angler count unless the fishery's rules allow it. Several federal fisheries specifically exclude crew from the bag calculation on for-hire trips.

Practice workbook

📊

Download the free Charter Fishing: Boat Limit For The Trip practice workbook

Edit the yellow anglers, per-angler, and vessel-limit cells; the binding limit recalculates.

Frequently asked questions

Is this a substitute for reading the regulation?

No. It is a way to apply a regulation you have already read consistently across a season of trips. The authoritative source is always the current rule for your fishery and zone, and this sheet should be updated the day a rule changes.

How do I handle aggregate limits across species?

Add a row per species and a total row with an aggregate cap, then wrap the total in another MIN against the aggregate. It is the same structure applied one level up.

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

Function references: MIN PRODUCT