Two dogs from the same house are not twice the work. Charge the full rate for the first dog and a discounted rate for each additional one — one formula prices any household.
Three dogs at a $25 rate with a 40% additional-dog discount: $25 + 2×$15 = $55 per walk.
The example
Three households, each with a dog count, base rate, and additional-dog discount.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Client | Dogs | Rate (1st) | Addl disc | Walk total |
| 2 | Duke +2 | 3 | $25 | 40% | $55.00 |
| 3 | Solo Bella | 1 | $25 | 40% | $25.00 |
| 4 | Pair walk | 2 | $28 | 50% | $42.00 |
The formula
The first dog pays full freight; the rest ride discounted:
How it works
Break the household into first dog and the rest:
C2is the full per-walk rate, charged once for the first dog.(B2-1)counts the additional dogs — zero for a single-dog home.C2*(1-D2)is the discounted rate each extra dog pays; multiply and add.
A single-dog household collapses cleanly: (1-1) zeroes the second term, leaving just the base rate.
Try it: interactive demo
Enter dogs in the household, your rate, and the additional-dog discount.
Variations
Flat add-on per extra dog
Some walkers use a flat dollar add instead of a percent discount.
Monthly household invoice
Scale the per-walk price by walks per month.
Pitfalls & errors
Enter the discount as a percent-formatted cell (40%), not 40 — or the formula computes a negative rate for the extra dogs.
Cap pack size in policy, not in the formula — four dogs from one house may price fine and still be an unsafe walk.
Practice workbook
Frequently asked questions
What is a typical additional-dog discount?
Does this work for one dog?
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