Small Business
Inventory, sales pipelines, customer lists, and expenses.
Flag Inventory Items That Need Reordering
Compare stock on hand to each item's reorder point with IF, so low items flag themselves as Reorder the moment counts drop.
=IF(B2<=C2,"Reorder","OK")Calculate Sales Commission With a Flat or Tiered Rate
Multiply sales by the commission rate for flat payouts, or nest IF to apply tiered rates that rise with performance.
=B2*C2Track Job Applications by Status With COUNTIF
Count how many applications sit at each stage — Applied, Interview, Offer, Rejected — with COUNTIF on your tracker's status column.
=COUNTIF(D:D,"Interview")Calculate Sales Tax on an Order
Multiply the subtotal by the rate for the tax amount, or by one-plus-the-rate for the total — plus the formula that backs tax out of a total.
=B2*0.08Calculate a Discounted Price
Multiply the price by one minus the percent-off to get the sale price — and see why a 20% then 10% discount is not 30% off.
=B2*(1-C2)Calculate Your Break-Even Point
Divide fixed costs by price minus variable cost per unit to find how many units you must sell before the business stops losing money.
=B2/(C2-D2)