= 50 + (C2 * 2.5)

Here, $50 is the base fee, and $2.5 is charged per unit listed in cell C2.

Scenario B: Tiered rates based on quantity

=IF(D2<=10, D2*5, IF(D2<=50, D2*4.5, D2*4))

This gives a $5/unit rate for orders of 10 or fewer, $4.5/unit for 11–50, and $4/unit for more than 50.

3. Track International Shipping Fees

International shipping is often the most complex part of the cost puzzle. It typically involves weights, distances, and carrier rates.

Basic International Cost Formula:

= PRODUCT(E2, F2) + G2

Where E2 is the package weight, F2 is the cost per kilogram, and G2 is a fixed handling fee.

4. The Grand Total: Bringing It All Together

The real power comes when you synthesize every piece into a final landed cost.

= SUM(B2:B10) + (50 + (C2 * 2.5)) + (PRODUCT(E2, F2) + G2)

This master formula combines your total item prices, domestic freight, and international shipping into one automated result. Update any single variable—like the number of units or the shipping weight—and your total cost instantly recalculates.

Pro Tip: Name Your Ranges

Instead of using cryptic cell references like B2:B10, give that range a name like "ItemPrices." Then your formulas become human-readable:

= SUM(ItemPrices) + DomesticFreight + InternationalShipping

To name a range in FishGoo Spreadsheet, simply select the cells and type the name into the range box on the top left.

Stop Calculating, Start Automating

With FishGoo Spreadsheet, you’re not just building spreadsheets—you’re building a automated financial workflow. Implement these formulas today and reclaim your time.

Your bottom line will thank you.