Build clickable web, email, file, or in-workbook links with HYPERLINK.

Turn text into a live cell or sheet reference with INDIRECT.

Chain two lookups: result of one feeds the next.

Do a case-sensitive lookup with EXACT and INDEX/MATCH.

Make a named range that auto-grows with OFFSET + COUNTA.

Find the closest numeric value with INDEX/MATCH + MIN/ABS.

Return the label of the highest (or lowest) value.

Flip rows and columns with the live TRANSPOSE function.

Convert a column number to its letter with ADDRESS + SUBSTITUTE.

Show the current tab name in a cell with CELL and TEXTAFTER.

Return the first or last non-blank value with the LOOKUP trick or XLOOKUP.

Return the most recent (last) match with XLOOKUP search_mode -1 or the LOOKUP trick.

Look up across a header row and return a value below with HLOOKUP.

List every tab in the workbook with a GET.WORKBOOK named formula.

Look up across several sheets by chaining IFERROR.

Look up a whole column of values in one spilling formula.

Look up data on another sheet, optionally chosen with INDIRECT.

Look up a value to the left with INDEX/MATCH.

Return several columns from one lookup that spills the whole record.

Return the 2nd, 3rd, or nth match with FILTER+INDEX or INDEX/SMALL.

Look up a value on two or more keys at once by joining them inside XLOOKUP or INDEX/MATCH.

Partial-match lookup with * and ? wildcards.

ISNA wrapped around MATCH checks whether a typed code exists in the reference list BEFORE any downstream lookup formula runs against it, catching a typo at the point of entry instead of chasing a #N/A three formulas later.

Merge two tables by a key (a formula join).

Look up on a fragment using wildcards with VLOOKUP or XLOOKUP.

Sum or average the last N rows with a moving OFFSET window.

Land a number in the right tier or tax bracket with XLOOKUP match_mode -1 — no nested IFs.

Look up by row and column label with INDEX and two MATCHes.

Land in the right band on both axes of a rate grid with INDEX/MATCH.

Pull the value where a row and a column meet, with nested XLOOKUP or INDEX/MATCH/MATCH.

Look up a value by both a row label and a column label at once.

Two-way lookup with nested XLOOKUP (row x column).

Find the nearest tier with XLOOKUP match mode.

Return a default instead of #N/A with XLOOKUP.

Find the last (most recent) match with XLOOKUP search mode.

Build a cumulative running total with one anchored, expanding-range SUM (or SCAN).

Running total that resets for each group with SUMIFS.

Sum rows whose label contains a word with SUMIF wildcards.

Total a column on two or more conditions at once with SUMIFS (AND logic).

Add every Nth row with SUMPRODUCT and MOD on the row number.

Sum only filtered/visible rows with SUBTOTAL (or AGGREGATE).

Sum amounts that fall on weekdays or weekends.

Sum a range that has errors using AGGREGATE.

Total values that fall in a given month with SUMIFS and EOMONTH — year-safe, no helper column.

Total amounts for a quarter with SUMIFS and EOMONTH date boundaries.

Total rows whose label contains text using SUMIF with wildcards.

Sum magnitudes ignoring sign with SUMPRODUCT + ABS.

Add the same cell across many sheets with a 3D reference.

Total just the largest few values with LARGE and SUMPRODUCT — top 3, top 5, or N from a cell.

Sum where a field is one value OR another.

Build a region-by-month matrix report with one SUMIFS filled across and down.

Count rows that meet several conditions at once with COUNTIFS.

Count empty cells in a range with COUNTBLANK.

Count cells containing a word or fragment with COUNTIF and wildcards.

Count text, numbers, non-blank or blank cells with the right COUNT function.

Count dates that fall between two dates with COUNTIFS.

Count how many dates fall on a weekday with SUMPRODUCT and WEEKDAY.

Count distinct values that meet a condition.

Count numbers, non-blanks, and blanks separately.

Count rows matching any of several conditions.

Count how many distinct entries are in a list — COUNTA(UNIQUE()) or the classic SUMPRODUCT trick.

Count values above (or below) the average.

Count values between a low and high bound with COUNTIFS.

Count distinct values within each group with UNIQUE+FILTER or SUMPRODUCT.

Group numbers into bands and count each with FREQUENCY or COUNTIFS.

Number each occurrence of a value with an expanding COUNTIF.

Average a range but skip exact zeros with AVERAGEIF and a <>0 criterion — blanks are already ignored.

Average only filtered, visible rows with SUBTOTAL code 101 — updates live as you change the filter.

Average a column that contains errors with AGGREGATE option 6.

Average values for a given day of week with SUMPRODUCT and WEEKDAY — no helper column needed.

Average the values in one category with AVERAGEIF / AVERAGEIFS.

Average the most recent N values with OFFSET and COUNT (or TAKE in 365) — the window slides as data grows.

Average only the best few values by nesting LARGE inside AVERAGE.

Smooth a series with a rolling AVERAGE window that slides down the column.

Build a cumulative running average with AVERAGE and an expanding range — the mean of everything so far.

Weight some values more than others with SUMPRODUCT divided by total weight.

Weight recent points more with SUMPRODUCT — a responsive smoothed average divided by the weight total.

Clamp a number between a floor and ceiling with nested MIN and MAX.

Get the 2nd, 3rd, or nth largest/smallest value with LARGE and SMALL.

Find the biggest value in a given month with MAXIFS and date boundaries.

Find the largest value that meets a condition with MAXIFS.

Find the smallest value that meets a condition with MINIFS.

Replace #N/A and #DIV/0! errors with a clean fallback using IFERROR / IFNA.

Compare numbers within a tolerance (floating point).

Turn scores into letter grades with IFS, nested IF, or a lookup table.

Exclusive OR: TRUE when exactly one condition holds.

Fill blank cells with the value above using IF or Go To Special.

Mark or highlight repeated values with COUNTIF — labels and conditional formatting.

Flag rows meeting every condition with AND.

Grade or band values with the IFS function.

Make an IF decision on several conditions at once by nesting AND or OR.

Catch only #N/A (not all errors) with IFNA.

Choose between IFS, nested IF, and a lookup table.

Map a value to a result with SWITCH instead of nested IFs.

Show a default value when a cell is blank.

Convert TRUE/FALSE to 1/0 to count or sum.

Turn TRUE/FALSE into Yes/No, Pass/Fail, or tick/cross.

Test several conditions in order without stacking IFs inside each other.

Check that all required cells are filled.

Test whether a cell contains text with ISNUMBER and SEARCH.

Test whether a formula errored with ISERROR or ISNA.

Test whether a cell is empty with ISBLANK inside IF.

Tell real numbers from text-numbers with ISNUMBER and ISTEXT.

Count how many cells hold errors with SUMPRODUCT and ISERROR — audit a sheet in one formula.

Detect which cells contain formulas with ISFORMULA — audit a model or flag overwritten cells.

Branch on text vs numbers with ISNUMBER/ISTEXT.

Identify whether a value is a number, text, logical, or error with TYPE — branch logic on the kind.

Read a cell's address, column, type or filename with the CELL function — metadata for dynamic labels.

Test whether a number is even or odd.

Try several lookups in turn with nested IFERROR — the first hit wins, with a clean message if all miss.

Turn #N/A into 0, blank, or a message with IFNA — without hiding genuine errors like IFERROR does.

Capitalize names with PROPER, or force case with UPPER and LOWER.

Strip extra spaces, line breaks and non-breaking spaces with TRIM, CLEAN and SUBSTITUTE.

Turn numbers stored as text into real numbers with VALUE.

Convert numbers stored as text back to real numbers with VALUE or a math nudge (*1, --) so they sum.

Count characters excluding spaces with LEN + SUBSTITUTE.

Count how many times a word appears in a cell.

Count words in a cell by counting spaces with LEN and SUBSTITUTE.

Pull first and last names out of a full-name cell with TEXTBEFORE/AFTER or LEFT/RIGHT.

Pull the number out of mixed text with TEXTAFTER/VALUE or MID/FIND.

Pull text between two characters with TEXTBEFORE/AFTER or MID/FIND.

Extract text between parentheses with MID + FIND.

Pull the domain (after @) from an email with TEXTAFTER or MID/FIND.

Pull the part after the last dot — even when the name has several dots.

Pull the first word from a cell with LEFT + FIND.

Pull the last word with the TRIM/RIGHT/REPT trick.

Pull the nth word from a phrase with the SUBSTITUTE/REPT/MID trick.

Get the value after a label like Name: with SEARCH.

Find and replace several things at once with nested SUBSTITUTE.

Swap text inside a formula with SUBSTITUTE or REPLACE.

Find the position of the nth occurrence of a character with FIND/SUBSTITUTE.

Find where text appears in a cell with SEARCH/FIND.

Build initials from a name with LEFT/MID or TEXTSPLIT.

Draw in-cell bar charts, stars, and progress bars with REPT.

Insert special characters and inspect codes with CHAR, CODE and UNICHAR.

Combine a range of cells into one delimited string with TEXTJOIN — skips blanks.

Join an entire range of cells with TEXTJOIN or CONCAT.

Hide all but the last few characters with REPT and RIGHT.

Turn 1 into 1st, 22 into 22nd, 13 into 13th.

Add leading zeros to numbers to a fixed width with TEXT.

Fix PROPER's mistakes (McDonald, IBM) with SUBSTITUTE patches.

Scrub extra and hidden spaces from imported text with TRIM + CLEAN.

Flatten in-cell line breaks to spaces with SUBSTITUTE + CHAR(10).

Flatten in-cell line breaks to spaces with SUBSTITUTE + CHAR(10).

Strip digits from text, keeping letters, with REGEXREPLACE.

Strip unwanted characters with nested SUBSTITUTE (or keep only digits).

Reverse the characters in a string with TEXTJOIN, MID and SEQUENCE.

Capitalize only the first letter (sentence case).

Split letters from numbers in a code like ABC123.

Break one cell into columns on a delimiter with TEXTSPLIT (or LEFT/MID/FIND).

Split a delimited cell into rows (down a column) with TEXTSPLIT.

Convert Last, First into First Last and back.

Add (or subtract) working days to a date with WORKDAY.

Shift a date by whole months or years with EDATE.

Express an age or duration in weeks or total months.

Turn a birthdate into an age in whole years with DATEDIF and TODAY — updates itself daily.

Calculate hours between two times by subtracting and multiplying by 24.

Convert raw seconds into a readable h:mm:ss duration with TEXT.

Turn text dates into real dates with DATEVALUE or a DATE rebuild.

Convert a time like 8:30 to 8.5 decimal hours.

Show days remaining until a due date, with overdue handling.

Count how many Saturdays and Sundays fall between a start and end date.

Count working days between dates, skipping weekends and holidays, with NETWORKDAYS.

Count how many Mondays (etc.) are in a month.

Return whole weeks (and leftover days) between a start and end date.

Show days, hours, and minutes remaining to a target with NOW.

Count days on the 30/360 basis used in bond and accounting math with DAYS360.

Count days until or since a date with simple date subtraction and TODAY.

Compute days in a year, leap-aware (365 or 366).

Break an age into exact years, months, and days with DATEDIF.

Jump to the next specific weekday from a date with WEEKDAY and MOD.

Find the first or last day of a date's quarter.

Get the first or last day of any month with EOMONTH — leap-year safe.

Map any date to its fiscal year and quarter for non-January calendars.

Spill a list of evenly spaced dates (weekly, monthly) with SEQUENCE.

Get the calendar date that a given year and week number starts on.

Get the day-of-week name from a date with TEXT (dddd / ddd).

Turn a date into its calendar quarter with MONTH and ROUNDUP.

Get the ISO or US week number of a date with ISOWEEKNUM / WEEKNUM.

Total hours for a shift that crosses midnight with MOD.

Find the last (or first) business day of any month with WORKDAY + EOMONTH.

Turn a month number into its name (June from 6).

Count whole or calendar months between two dates.

Find the next anniversary, birthday, or renewal date with DATE.

Find the nth weekday of a month (3rd Thursday) with DATE and WEEKDAY.

Find how many days are in a month with EOMONTH and DAY (leap-safe).

Count overlapping days between two date ranges with MIN/MAX.

Round time to the nearest 15 minutes (or any interval) with MROUND.

Shift a date back a year for YoY comparisons with EDATE.

Split daily hours into regular and overtime with MIN and MAX.

Total hours past 24 using the [h]:mm format instead of letting them wrap.

Find which week of the month a date falls in.

Count business days between dates, skipping weekends and holidays, with NETWORKDAYS.

Count working days left until a deadline with NETWORKDAYS.

Aggregate an array to one value with REDUCE and LAMBDA.

Build a reusable custom function with LAMBDA + Name Manager.

Build a calculated grid from row/column positions with MAKEARRAY.

Append ranges into one with VSTACK and HSTACK.

Make a live cross-tab with PIVOTBY.

Pull every record matching a condition into a report area with FILTER (or INDEX/SMALL).

Filter rows on AND / OR conditions with FILTER.

Extract every row that meets a condition into a live, self-updating range with FILTER.

Flatten a grid into one column with TOCOL (or TOROW).

Spill a list of numbers, dates, or a grid with SEQUENCE.

Pad an array to a fixed size with EXPAND.

Pick and reorder rows or columns with CHOOSEROWS/CHOOSECOLS.

Reference a whole spill range with the # operator.

Fold a list into a grid of any width with WRAPROWS / WRAPCOLS.

Return a whole row of fields with one XLOOKUP.

Make running totals, max, or product with SCAN and LAMBDA.

Show each value as a share of total with PERCENTOF.

Sort a table by several keys with SORTBY (live formula).

Sort by a helper column or custom order with SORTBY.

Split a cell into columns (or a grid) with TEXTSPLIT.

Grab text before or after a delimiter with TEXTBEFORE/TEXTAFTER.

Summarize each row or column with BYROW / BYCOL.

Build a grouped summary in one formula with GROUPBY.

Transform every value of an array with MAP and LAMBDA.

Keep or remove the first/last rows with TAKE and DROP.

Build a distinct list with counts (UNIQUE + COUNTIF).

Turn a column with repeats into a clean, alphabetized list with SORT(UNIQUE()).

Count selections and arrangements with COMBIN, PERMUT and FACT.

Convert between decimal, binary, hex and octal with DEC2BIN/HEX2DEC.

Convert miles, kg, Celsius, hours and more with the CONVERT function.

Cycle through a list repeatedly with MOD — round-robin assignment, alternating bands, repeating schedules.

Straight-line distance between two points with SQRT and SUMSQ — the Pythagorean theorem in 2D or 3D.

Compute n! and build permutations and combinations with FACT, COMBIN and PERMUT.

Generate random numbers and random picks with RANDBETWEEN and RAND.

Find the greatest common divisor and least common multiple, and simplify ratios.

INT vs TRUNC: both drop decimals, but they differ on negatives — chop toward zero vs round down.

Take logs in any base with LOG, LN and LOG10 — for growth rates, decibels, pH and doubling time.

Multiply every value in a range with PRODUCT (compound factors).

Multiply arrays and add, or count/sum on multiple conditions, with SUMPRODUCT.

Raise to a power, take any root, or compute e^x with POWER, SQRT and EXP.

Raise to powers and take square or nth roots with POWER, ^ and SQRT.

Generate a random decimal in any range with RAND — scaled and shifted for simulations and test data.

Shuffle a list or sample without duplicates using SORTBY + RANDARRAY.

Get remainders and build cycles, odd/even tests and wraps with MOD.

Convert numbers to Roman numerals and back with ROMAN and ARABIC.

Build a cumulative product with PRODUCT and an expanding range — compound growth factors and indices.

Split a total into whole groups and a remainder with QUOTIENT and MOD.

Square every value and total them in one function with SUMSQ — the basis of variance, distance and least-squares.

Use SIN, COS and TAN with degrees by wrapping angles in RADIANS — heights, distances and angles.

Rank a list highest-to-lowest with RANK.EQ, including a no-gaps tiebreaker.

Build a running cumulative percent (Pareto).

Calculate percent change and percent of total — the right base and formatting.

Always round up or down with ROUNDUP, ROUNDDOWN, CEILING and FLOOR.

Round halves down (2.5 to 2) instead of away from zero with a ROUNDUP minus-0.5 trick.

Round up or down to the nearest multiple — to the next $5 or down to 100 — with CEILING, FLOOR and MROUND.

Round a percentage cleanly by rounding the underlying decimal — 2 places for whole percent, 3 for one decimal.

Round money cleanly to cents, nickels or whole dollars with ROUND and MROUND — fix floating-point pennies.

Round up to the next even or odd integer with EVEN and ODD — for pairs, panels and centered counts.

Round to N significant figures with ROUND and LOG10.

Round to the nearest thousand or million with ROUND and negative digits — cleaner dashboard figures.

Round to the nearest 0.5 (or quarter, dime) with MROUND, CEILING and FLOOR — for half-step pricing.

Round to decimal places with ROUND or to any multiple with MROUND.

Turn a lump sum into a level monthly payout.

Find the lump-sum balloon owed at loan maturity.

Find the units needed to cover costs (fixed / contribution margin).

Compute the compound annual growth rate from a start and end value.

Find how many units you must sell to cover fixed costs.

Calculate a fixed loan payment from rate, term and amount with PMT.

Grow a lump sum with the compound interest formula (1+rate)^periods.

Find how long a card balance takes to clear with NPER.

Depreciate an asset with SLN, DDB, or SYD (straight-line vs accelerated).

Value future cash flows today with a DCF (NPV).

Compute dividend yield and annual income.

Estimate doubling time with the Rule of 72 and compute it exactly with NPER.

Convert nominal to effective annual rate (APR to APY) with EFFECT/NOMINAL.

SUM totals monthly debt payments and divides by gross monthly income to produce the debt-to-income ratio lenders use to gauge how much of your income is already committed before a new loan payment is added.

Compute the full PITI mortgage payment with taxes & insurance.

Project what regular savings grow to with FV and compound interest.

See how extra payments shorten a loan with NPER.

Find an interest-only loan payment.

Find an investment's annual return where NPV is zero with IRR.

Split each loan payment into interest and principal with IPMT and PPMT.

Find the monthly deposit to reach a savings goal with PMT.

Value future cash flows in today's money with NPV (initial added outside).

Find what future money or payments are worth today with PV.

Price a bond as the present value of its cash flows.

Tell profit margin from markup, and price for a target margin.

Compute return on investment and payback period.

Adjust a return for inflation (Fisher equation).

Find the deposit to reach a target by a future date.

Value a payment that lasts forever (C/r).

Calculate annualized return on irregular cash-flow dates with XIRR.

Find a bond's yield to maturity with RATE.

Age unpaid invoices into 30/60/90-day buckets.

Allocate a shared cost across departments by weight.

Annualize a year-to-date figure into a full-year run-rate.

Apply a discount then tax in the right order.

Back out the tax from a tax-inclusive price.

Bill hours at different rates with SUMPRODUCT.

Compute budget vs actual variance in dollars and percent.

Compare two loans by payment and total interest with PMT.

Find contribution margin per unit and as a ratio.

Convert currency with a maintained exchange-rate table.

Spread fixed plus variable costs into a per-unit cost.

Take gross pay down to net with stacked deductions.

Flag low stock and compute how much to reorder.

Total an invoice's line items and tax with SUMPRODUCT.

Compare the net cost of leasing versus buying.

Look up the right sales-tax rate by region with VLOOKUP.

Chain cost-to-wholesale-to-retail markups correctly.

Calculate markup and margin from cost and price, and convert between them.

Find the payback period from a cash-flow stream.

Roll a sales log into profit by product with SUMIFS.

Sum a trailing 12-month (TTM) window that slides forward.

Keep a running cash balance as money comes in and out.

Pay a sales commission that steps up by tier with VLOOKUP.

Add a tip and split a bill among people.

Apply volume/quantity discount pricing with a break table.

Add tiny in-cell line, column, or win/loss sparkline charts.

Make a chart auto-expand with new data (Table or OFFSET).

Build a KPI card with a value and up/down delta.

Build a bullet chart (actual vs target vs bands).

Combine columns and a line on two axes.

Put custom text labels on chart points from cells.

Make a goal thermometer that fills toward a target.

Build a histogram by binning with FREQUENCY.

Link a chart title to a cell so it updates itself.

Draw a percent-of-goal progress bar with REPT.

Build a waterfall (bridge) chart with helper columns.

Show streaks with a direction-only win/loss sparkline.

Add a calculated field (like margin %) inside a PivotTable.

Compare best/base/worst scenarios with a selector and CHOOSE.

Find break-even by driving profit to zero with Goal Seek.

Solve backward for the input that hits a target with Goal Seek.

Group PivotTable dates into months, quarters, or years.

See how a loan payment moves as the rate changes.

Sweep one input across a range with a data table.

Model total profit from a product mix with SUMPRODUCT.

Pull a PivotTable value by field name with GETPIVOTDATA.

Show PivotTable values as a percent of the total.

Solve the price needed to hit a profit target.

Build a result grid varying two inputs at once.

Track the highest value seen so far down a column with an expanding MAX.

Compare relative spread across datasets with STDEV / AVERAGE.

Put a margin of error around a sample mean with CONFIDENCE.

Measure how two columns move together with CORREL (-1 to +1).

Measure whether two variables move together with COVAR.

Flag outliers with the IQR rule (QUARTILE) or a z-score test.

Project future values along a trend with TREND.

Project a future value along a trend line with FORECAST or TREND.

Average compounding growth rates correctly with GEOMEAN.

Average rates and ratios correctly with HARMEAN.

Measure average spread with AVEDEV — the mean absolute distance from the average, robust to outliers.

Compare mean, median, and mode for the center.

Find the median within a group with MEDIAN+FILTER or MEDIAN(IF()).

Find the most frequent value (number or text) with MODE.

Rescale values to a 0-1 scale (min-max).

Compute percentiles and quartiles with PERCENTILE and QUARTILE.

Find a value's percentile standing within a dataset with PERCENTRANK.

Measure how well a line fits with R-squared (RSQ).

Measure spread with the range and interquartile range.

Rank values within each group with COUNTIFS.

Get a regression line's slope and intercept.

Track changing volatility with a rolling standard deviation.

Describe distribution shape with SKEW and KURT.

Measure spread with STDEV.S (sample) or STDEV.P (population).

Find how precise a sample mean is (standard error).

Finds the gap between a class's actual average score and a target average, then adds that same gap to every score, so the whole distribution shifts up (or down) while each student keeps their relative rank.

Average after dropping the extreme high and low values with TRIMMEAN.

Compute sample or population variance (VAR.S/.P).

Average prices by quantity so big lots count more than small ones.

Measure how many standard deviations a value is from the mean.

Clean and reformat text by pattern with REGEXREPLACE.

Color or change format by value with bracketed conditions.

Control how numbers display with custom format codes.

Display big numbers as K or millions with a format code.

Extract text by pattern with REGEXEXTRACT.

Format phone or ID numbers without changing the value.

Hide zeros or show a dash with a number format.

Build a clean custom function with LAMBDA + LET.

Name values inside a formula for clarity and speed with LET.

Write a LAMBDA that calls itself to loop without VBA.

Save a LAMBDA as a reusable custom function in Name Manager.

Validate text format with REGEXTEST (TRUE/FALSE).

Add alternating row shading with ISEVEN(ROW()) — zebra stripes.

Build a live Gantt chart from start/end dates with a CF formula.

Turn numbers into a color-gradient heat map with Color Scales.

Shade every cell that contains a formula (ISFORMULA).

Highlight cells above or below the group average automatically.

Highlight values above a threshold from a cell.

Highlight cells that mention a keyword with ISNUMBER + SEARCH.

Light up every cell that evaluates to an error with ISERROR.

Flag cells that are the wrong length with LEN.

Auto-colour rows whose expiry date is within the next 30 days.

Highlight where two columns differ.

Turn overdue dates red and upcoming ones amber with TODAY.

Shade every value that appears more than once with a COUNTIF rule.

Shade every Nth row with a MOD rule.

Highlight future (or past) dates vs TODAY.

Flag missing required entries with a blank rule.

Highlight values that appear exactly once.

Highlight rows missing any data with COUNTBLANK in a CF rule.

Highlight whole rows with a formula rule — the $C2 mixed-reference trick.

Flag entries not on an allowed list with COUNTIF.

Shade Saturdays and Sundays in a date list with WEEKDAY.

Draw a line where a sorted group changes.

Light up a whole row based on one cell using a mixed reference.

Flag the highest and lowest values with MAX/MIN rules.

Highlight the top 10% by value with PERCENTILE.

Shade the top N values with a LARGE-based conditional-formatting rule.

Turn a column of numbers into in-cell data bars.

Band by group, not just every other row, with a group counter.

Strike through tasks marked done with a CF rule.

Add traffic-light icons with your own number thresholds.

Build a drop-down list with Data Validation so entry is pick-from-a-menu.

Make a cascading drop-down where the second list depends on the first (INDIRECT).

Block duplicate entries with a COUNTIF data-validation rule.

Limit a cell to whole numbers or a value range with Data Validation.

Block entries that are too long or short with text-length validation.

Earn PTO as a rate per hour worked, rounded and capped to your plan.

Count staff active in any month from hire and termination dates with SUMPRODUCT.

Total benefit costs divided by covered headcount for budgeting and benchmarking.

Split hours into regular and overtime and total the pay.

Compare pay to range midpoint (1.00 = at midpoint) for equity and positioning.

Divide salary by 2,080 hours for an hourly rate; multiply to reverse it.

Show exact length of service in years, months and days with DATEDIF.

Separations divided by average headcount, as a percentage, with AVERAGE.

Capped Social Security (6.2%) plus uncapped Medicare (1.45%) with MIN for the wage cap.

Spill a year of every-14-day paydays from a start date with SEQUENCE.

Scale a full-period salary by the fraction of days actually worked, rounded to the cent.

Round punch times to the nearest 15 minutes for clean payroll totals.

Apply night/weekend premiums as a rate multiplier or flat add with IF or a lookup.

Pay regular, 1.5x and 2x bands correctly with MIN, MAX and MEDIAN as a clamp.

NOI divided by property value — the income yield used to compare and value properties.

Annual cash flow divided by the actual cash you invested — the leveraged return on your money.

NOI divided by annual debt payments — the coverage ratio lenders use to size loans.

Price divided by annual gross rent — a fast screening ratio for income properties.

Loan amount divided by property value — the lender's core risk and equity gauge.

70% of after-repair value minus repairs — the flipper's maximum allowable offer.

Effective income minus operating expenses (before the mortgage) — the base metric for property analysis.

Price divided by living area — the size-normalized metric for comps and valuation.

Layer commission, side share and agent split to find the agent's take from a sale.

Annual rent as a percentage of value — gross uses rent alone, net subtracts expenses.

Flag whether monthly rent clears 1% of price — a fast rental screening check with IF.

Discount potential rent by an expected vacancy rate for realistic effective income.

Band inventory items A/B/C by their cumulative share of value with nested IFs.

Average beginning and ending (or monthly) stock — the base for turnover and DIO.

Average inventory over COGS times 365 — how many days stock sits before selling.

The square-root formula for the order size that minimizes ordering plus holding cost.

Gross-margin dollars per dollar of inventory — margin and turnover combined.

Book stock minus physical count, over sales — inventory lost to theft, damage and error.

COGS divided by average inventory — how many times stock cycles in a period.

Margin is profit over price, markup is profit over cost — plus how to convert and price.

Sale price, saving, and correctly stacked markdowns for clearance and promotions.

Lead-time demand plus a safety buffer — the stock level that triggers a reorder.

Units sold divided by units received — how fast a product moves through stock.

Units on hand divided by the sales rate — how many weeks of supply you hold.

Room revenue divided by rooms sold — the average rate achieved per occupied room.

Cost per pour divided by drink price — the bar's pour cost (target 18–24%).

Fixed costs divided by margin per cover — the number of guests needed to break even.

Cost of food sold divided by food sales — the headline kitchen metric (target 28–35%).

Rooms sold divided by rooms available — the foundation hotel occupancy metric.

Total payroll divided by sales — the labor half of cost control (target 25–35%).

Divide plate cost by a target food cost % to set a menu price that hits your margin.

Gross up recipe cost by a waste rate so sold dishes carry spillage and comps.

Food plus labor cost over sales — the controllable 'prime cost' (target ~60% or less).

As-purchased cost divided by yield — the real cost of the usable portion after trim loss.

Room revenue per available room — ADR times occupancy, the hotel headline metric.

Each worker's hours over total hours times the pool — a fair, proportional tip split.

Days present over total, or COUNTIF of 'P' marks — the attendance percentage.

Rank grades highest-first with RANK, plus tie-broken and dense ranking add-ons.

Add capped points or scale to the top score — common grade-curving methods in one formula.

Subtract the minimum and divide by n−1 — average with the worst grade dropped.

Credit-weighted average of grade points — the GPA, via SUMPRODUCT over points and credits.

Rearrange the weighted-grade formula to solve for the score needed on the final.

Point gain and percent (and normalized) improvement from pre-test to post-test.

Map a numeric score to a letter with an approximate-match LOOKUP against a grade scale.

Compare a score to a cutoff with IF — pass/fail, bands, and points-needed-to-pass.

Sum points earned over points possible for a transparent, criterion-based rubric grade.

Count mastered standards over total assessed — the standards-based mastery percentage.

Multiply each category score by its weight and sum — the weighted course grade with SUMPRODUCT.

Divide direct cost by (1 − overhead − profit) to bid for a true margin, not a markup.

Thickness × width (inches) × length (feet) ÷ 12 — board feet of lumber for pricing.

Sum a change's direct costs, apply markup, add to the contract for the revised price.

Length × width × thickness in feet, divided by 27 — cubic yards of concrete to order.

Total cost divided by finished area — the per-square-foot benchmark for budgeting.

Area plus waste, divided by box coverage, rounded up — flooring boxes to order.

Quantity over crew output for elapsed hours; times crew and wage for labor cost.

Multiply needed quantity by a waste factor and round up to whole units to order.

Area times coats divided by coverage per gallon, rounded up — paint gallons to buy.

Withhold a retention percentage from each draw — net payment and held balance.

Roof area divided by 100 for squares, plus waste and bundles-per-square — shingle order.

Length times width in feet — the square-footage base for nearly every estimate.

The 28.7×A1C−46.7 conversion to estimated average glucose in mg/dL.

Missed appointments over scheduled, counted with COUNTIF — the clinic no-show rate.

Mifflin–St Jeor BMR times an activity factor — estimated daily calorie needs.

Weight over height squared (or the 703 factor for imperial) — the BMI screening ratio.

The Mosteller square-root formula for body surface area, for m²-based dosing.

The Cockcroft–Gault estimate of kidney function from age, weight and creatinine.

Patient-days over available bed-days — the hospital capacity-utilization rate.

Volume times drop factor over minutes — IV drops per minute for a gravity infusion.

Weight, height and glucose conversions (and the CONVERT function) for clinical sheets.

Clark's (weight) and Young's (age) rules to estimate a child's dose from the adult dose.

Max heart rate (220−age) times a zone percentage — training heart-rate targets.

Dose per kilogram times body weight — the base weight-based dosing calculation.

Total raised over the number of gifts — average gift, best read beside the median.

Fundraising cost divided by dollars raised — the efficiency ratio (lower is better).

Average annual giving times expected donor lifespan — donor lifetime value.

Retained donors over prior-year donors — fundraising's key retention metric.

Raised over goal, capped at 100% — the campaign-thermometer progress percentage.

Net raised over cost — fundraising ROI, framed the way boards expect.

Grant total times each category percent, tied out to the award — a clean grant budget.

Donation times the match ratio, capped — matched amount and combined total.

Dollars collected over dollars pledged — the pledge fulfillment reality check.

Program expense over total expense — the program-vs-overhead efficiency ratio.

Total volunteer hours times an hourly value (or role rates) — the in-kind contribution.

This year's donors minus last year's, over last year — the YoY growth trend.

Billable hours over available hours — the agency/freelancer utilization metric.

Hours-weighted average of role rates — the blended team rate, via SUMPRODUCT.

Fee times each milestone percent, final as remainder — a deposit/milestone schedule.

Project fee divided by actual hours — what a fixed price really paid per hour.

Target income plus costs over realistically billable hours — a sustainable freelance rate.

Balance times rate prorated by days overdue (floored at zero) — an invoice late fee.

Cost times one plus the markup — the client price on a fronted pass-through cost.

Revenue minus cost to serve, by client with SUMIF — who's actually profitable.

Estimated hours times rate, summed and buffered — a fixed-price project quote.

Income times an effective tax rate, set aside per payment — quarterly tax savings.

Allotment minus hours logged this period — retainer hours left, with overage flagged.

Actual hours minus budget (floored), with percent over and unbilled cost — scope creep.

Won revenue over won-deal count — average deal size, best read with the median.

CAC over monthly gross margin per customer — months to recoup acquisition cost.

Show each rep's actual sales as a percent of quota, with status.

Each stage's count over the prior stage — pinpoints where the funnel leaks.

Sales and marketing spend over new customers — customer acquisition cost (judge vs LTV).

Customers (or revenue) lost over the starting count — the subscription churn rate.

Customers won over total leads — end-to-end funnel conversion, for planning demand.

Sum active monthly fees for MRR, times 12 for ARR — recurring-revenue basics.

Open pipeline over the quota gap — coverage ratio (benchmark ~1/win-rate).

Actual sales over quota — the headline sales-scorecard attainment percentage.

Opps times win rate times deal size, over cycle days — revenue per day (sales velocity).

Deals won over total closed deals — the core sales win-rate metric.

Each deal's value times its win probability, summed — the weighted sales forecast.

Revenue over orders — average order value, a direct multiplier on the top line.

One over gross margin — the ROAS at which ad margin just covers spend.

One minus completed over started carts — the cart abandonment rate.

Clicks over impressions — click-through rate, the funnel's first conversion.

Spend per click (CPC) and per conversion (CPA) — what clicks and customers cost.

Marketing spend over leads generated — cost per lead (carry it through to cost per customer).

AOV times frequency times lifespan (and margin) — e-commerce customer lifetime value.

Orders over sessions — the store conversion rate (pair with AOV for revenue/visit).

Opens and clicks over delivered (plus click-to-open) — email campaign rates.

Refunds over orders (or dollars) — the return rate and its hit to net revenue.

Customers with 2+ orders over total customers — the repeat purchase (loyalty) rate.

Ad revenue over ad spend — ROAS, judged against your margin-based break-even.

Look up a shipping rate from a weight band with approximate-match VLOOKUP.

The Navy tape formula (LOG10 on waist, neck, height) — estimated body-fat percentage.

Find the percentage of members who cancelled this month.

MET times weight (kg) times hours times 1.05 — estimated calories burned in a session.

Attendees over class capacity — how full gym/studio sessions run.

The Epley formula weight × (1 + reps/30) — estimated one-rep max from a set.

Cancellations over starting members — gym churn, retention, and average stay.

Calories times macro percent over calories-per-gram (4 or 9) — macros in grams.

Current weight times (1 + increment), rounded to loadable — next session's target.

Time divided by distance, formatted with TEXT — running pace per mile or km.

Steps times stride over 5,280 — distance from a step count, plus rough calories.

1RM times percent rounded to a loadable weight, plus plates per side — programming math.

Sets times reps times weight, summed with SUMPRODUCT — weekly training volume load.

Pounds to lose over weekly loss (deficit×7/3500) — an estimated weight-loss timeline.

Price premium over annual fuel savings — payback years on an efficiency upgrade.

Gas price/MPG vs kWh-per-mile times electricity price — EV vs gas cost per mile.

Active vehicle-days over available vehicle-days — fleet utilization and idle capacity.

Distance over MPG times fuel price — the fuel cost to plan any trip.

Loan PMT vs lease depreciation plus rent charge — the monthly lease-vs-buy comparison.

Last service plus interval minus current miles — miles until the next service is due.

Business miles times a per-mile rate — mileage reimbursement for expense reports.

Miles over gallons — fuel economy (use total/total for lifetime, not averaged ratios).

Approximate-match LOOKUP on cost bands times (1 + markup) — a shop parts-markup matrix.

Depreciation plus fuel, insurance, maintenance and financing — a vehicle's true TCO.

Total annual cost over annual miles — the all-in cost per mile for pricing routes.

Price times retained fraction to the power of years — a declining-balance car value.

Guests times hours times a per-guest rate, rounded up — bar quantities to stock.

Total budget times each category percent, tied out — an event budget allocation.

Event date minus TODAY for a live countdown, minus lead times for task due dates.

Service charge and tax compounded, plus a separate gratuity — the real event total.

SUMIF of party sizes for Yes RSVPs — the true headcount, plus-ones included.

COUNTIF each entrée from the RSVP list — the meal tally to give your caterer.

Per-plate price times guest count — the catering food total to start an event budget.

Replies over invitations, with an acceptance-rate forecast — the RSVP projection.

Guests times a per-guest factor plus a buffer, rounded up — rental quantities to order.

Guests over seats per table, rounded up — the tables an event needs.

All-in event cost over headcount — cost per guest (the biggest lever is the list).

Total minus deposit (with a due date) — the vendor balance and payment schedule.

Trim, clean, uppercase and de-punctuate into one canonical key — fix mismatched lookups.

Strip currency symbols and commas, then VALUE — text amounts become summable numbers.

MAXIFS finds the latest date recorded for each key, then a simple comparison flags every row as Keep or Superseded, so an import with repeated updates to the same record resolves to the current version.

Pull every digit out of mixed text and hand back a real number.

The text between // and the next slash — the domain pulled from a full URL.

IF blank take the value above, else keep — fill down a sparse group-label column.

A running COUNTIF that equals 1 on the first occurrence — flag firsts vs duplicates.

TEXTJOIN with ignore-empty TRUE — join a range cleanly, with no gaps from blanks.

Swap CHAR(160) for a space, CLEAN, then TRIM — the fix when TRIM alone fails.

FIND the opening parenthesis, LEFT everything before it, TRIM the space — and append a "(" to the search text so rows with no parentheses pass through untouched.

FIND the delimiter and slice with LEFT/MID (or TEXTSPLIT) — split one cell into fields.

Break 'Dallas, TX 75201' into City, State, and ZIP columns.

Separate 'First Last' into two columns with classic text functions.

Strip non-digits then TEXT-format — phone numbers in one consistent layout.

Normalize case/spaces, then map affirmative variants to a clean Yes/No.

IF length over N, take LEFT and add … — tidy truncation for labels and reports.

Check for an @, a dot after it, and no spaces — a basic email format validator.

TODAY() minus the last-updated date shows how stale a dashboard metric is, and a simple IF turns that day count into a Fresh or Stale flag so a broken data feed is visible at a glance instead of hiding behind an unchanged-looking number.

A dropdown selector driving INDEX/MATCH KPIs — the core interactive-dashboard pattern.

LARGE for the Nth value, INDEX/MATCH for its name — a live, auto-ranking top-N list.

A custom number format with trailing commas — show millions as 1.2M without losing the value.

REPT a block character proportional to a percent — an in-cell bar with no chart.

One COUNTIF per status with totals and percentages — a live KPI status board.

A nested IF returning ▲/▼/● vs target — the at-a-glance KPI status indicator.

Label plus TEXT-formatted NOW (captured for accuracy) — a dashboard freshness stamp.

Band a metric Red/Amber/Green against thresholds with IFS — the universal status signal.

Add a cumulative running total and each row's share of the whole.

A scrollbar-driven start cell plus INDEX — page a fixed window through a long list.

CHOOSE (or INDEX) on a selector cell — flip one tile or chart between metrics.

Compare the latest point to the prior (or an average) for a ▲/▼/▬ trend symbol.

Arrow by direction plus a signed-percent TEXT — a compact variance indicator.

COUNTIF a key column > 1 flags duplicates — protect lookups and totals from repeats.

Compares the span between the smallest and largest number in a sequence against how many numbers are actually present, so a missing invoice or check number shows up as a count mismatch without listing every number by hand.

Rounded SUM of shares = 1 (or 100) — verify an allocation adds up before trusting it.

COUNTBLANK of the required range = 0 means complete — a form/import completeness check.

Summary total minus the detail sum (rounded) = 0 — a self-auditing tie-out check.

SUM plus COUNTA as a fingerprint (and a weighted checksum) — verify a clean data transfer.

Sum of row totals minus sum of column totals = 0 (after ROUND) — a grid integrity check.

Wrap risky formulas in IFERROR with a fallback — stop one error cascading through totals.

ISFORMULA FALSE in a calculated range flags typed-in overrides — stop silent model decay.

COUNTIF against a master list = 0 flags unapproved entries — audit data already entered.

IF with OR: a transaction date before the period start or after the period end gets a flag, so a September report cannot quietly include an August invoice.

Mark rows that are exact duplicates across several columns, not just one.

IF the value breaks min or max, flag it — a one-column data-entry validation report.

COUNTIF each item against the other list (both ways) — find what doesn't reconcile.

ABS of the difference ≤ tolerance — pass small, expected gaps without false alarms.

Run time over units = cycle time, checked against takt — find the line's bottleneck.

Defect fraction times a million — PPM, the high-precision quality measure (Six Sigma = 3.4).

Unplanned stop time over planned time — downtime %, the inverse of availability.

Units passing first time over units in, multiplied across steps — rolled first-pass yield.

Earned standard hours over actual hours — labor efficiency vs standard (100% = on standard).

Availability times performance times quality — the OEE productivity score.

Actual output over max capacity — production utilization for shift and capex decisions.

Sum of MIN(actual, planned) over total planned — honest schedule attainment by item.

Defective units over total produced — the scrap rate (yield is its complement).

Available time over demand — the takt pace every workstation must keep to meet demand.

Good units over hours run — throughput, and the basis for run planning and performance.

Stock over per-unit need (rounded down), then MIN — units buildable from a BOM.

ROUND(total × share, 2) with a last-row plug — allocate a combined fee so the parts tie out.

SUMIFS the hours where matter and billable flag match — billable hours and fees per matter.

SUMPRODUCT(hours, rates) over SUM(hours) — the hours-weighted blended attorney rate.

Recovery times fee % for the fee; recovery minus fee minus costs for the client net.

WORKDAY(trigger, days, holidays) for court days; trigger+days for calendar days — court deadlines.

Fees to date over budget — matter burn, with projected-at-completion to catch cap overruns.

Billed over worked value — realization, the share of effort that becomes billed (and collected) money.

IF(balance < floor, target - balance, 0) — the retainer top-up needed to refill to target.

CEILING(minutes/60, 0.1) — round raw minutes up to the next billable tenth of an hour.

EDATE(accrual, years*12) — the statute-of-limitations bar date, with an early-warning countdown.

Per-client deposits minus disbursements via SUMIFS — trust/IOLTA balances that never go negative.

Worked value minus write-down for the net bill; billed minus write-off for net receivable.

Cost per acre over yield per acre — the break-even price each bushel must clear.

Breeding date plus gestation length — projected calving/farrowing due dates with a countdown.

Total harvest over acres — yield per acre, the basis for revenue and field comparison.

Target nutrient over the analysis fraction — pounds of fertilizer product per acre.

Revenue per acre minus variable cost per acre — gross margin to rank crop enterprises.

Wet weight scaled by the dry-matter ratio — dry-weight grain at market moisture, and shrink.

Opening plus births and purchases minus deaths and sales — the closing herd count.

Acres times inches for acre-inches; ×27,154 for gallons — the irrigation water requirement.

Head times daily ration for feed per day; inventory over daily for days of supply.

Ownership plus operating cost over acres covered — machinery cost each acre carries.

Rate times acres, divided by bag size and rounded up — total seed and bags to buy.

Animal units over acres — stocking rate, matching grazing pressure to pasture.

Total revenue over clients served — average ticket, the spend per visit to grow.

Revenue minus rent vs revenue times commission — compare salon pay models and break-even.

Booked hours over available hours — chair/room utilization and the cost of idle capacity.

Returning clients over eligible — retention, with new-client retention as the growth metric.

Grams used times cost per gram (tube price ÷ tube grams) — exact color cost per service.

Cards sold minus redeemed — outstanding gift-card liability, recognized as revenue on use.

No-shows over booked appointments — the no-show rate and the revenue it costs.

Rebooked clients over total served — rebooking rate, the best leading indicator of retention.

Retail sales over service sales — the retail-to-service ratio, a measure of product selling.

Service revenue over hours worked — stylist revenue per hour, normalized for schedule.

Price minus product cost for service margin; cost over (1−target) to price for a margin.

ROUND(pool × share, 2) with a last-person plug — split a tip pool so the parts tie out.

Base price plus MAX(extra spreads, 0) times the per-spread rate — album pricing.

Costs plus salary over billable hours — the CODB rate that keeps a creative business solvent.

Total times deposit % for the retainer; total minus deposit for the balance, installments plugged.

Base fee times a usage-tier multiplier via VLOOKUP — license fees that scale with usage.

SUMPRODUCT item value times (1 − discount) — build and price photography packages.

Lab cost times the markup multiple for retail; margin = 1 − 1/multiple.

Total revenue over shoots — average per shoot, split by type to find what builds the business.

Second-shooter hours times their rate, netted against added revenue — does the help pay off?

Session price minus all costs for profit; divide by hours to compare bookings fairly.

Shoot hours times the edit ratio — total project time so editing labor gets priced in.

Frames times file size over 1024 for GB per shoot; times copies for real drive needs.

MAX(miles − free radius, 0) times the per-mile rate — billable travel beyond a free zone.

Divide a shoot fee by all the hours it really takes.

Total CAM times the tenant's sqft share, trued up against estimates — CAM reconciliation.

Collected rent over gross potential — economic occupancy, versus the physical door count.

IF(days late > grace, fee, 0) — rent late fees with grace, percent, per-day, and caps.

Lease end minus today — days to expiration, flagged into renewal windows to avoid surprise vacancies.

Total maintenance over units — cost per unit, broken out by category to find the money pits.

Collected rent times the management rate — the property manager's fee, with minimums.

Monthly rent over days in month times days occupied — prorated move-in/move-out rent.

Base rent times (1 + rate)^years — compounded annual rent escalation over a lease term.

SUMIF occupied rent, COUNTIF vacancies, AVERAGEIF by type — rent-roll totals and summaries.

Deposit minus itemized deductions — security-deposit refund, or the balance the tenant owes.

Rent over gross income — the rent-to-income ratio, with the income multiple as its inverse.

Lost rent for vacant days plus make-ready — the true cost of a unit turnover.

Premium times the commission rate — agent commission, with new vs renewal rates.

Loss minus deductible, floored at zero and capped at the limit — the insurance payout.

Loss times carried-over-required coverage (capped at 1) — the coinsurance underinsurance penalty.

Claims plus expenses over earned premium — combined ratio, underwriting profit below 100%.

Extra deductible over annual premium saving — claim-free years to break even on a higher deductible.

Manual premium times the EMR — experience-mod impact, a credit below 1.0 or surcharge above.

Debt + income×years + mortgage + education, minus existing coverage — DIME life-insurance need.

Claims incurred over premiums earned — loss ratio, the core underwriting metric.

Annual premium over 12 plus the installment fee — monthly premium and the convenience surcharge.

Loss capped at the sublimit, then the policy limit — covered amount under layered caps.

Premium times days remaining over 365 — pro-rata refund, with a short-rate penalty option.

Replacement cost times remaining-life fraction — actual cash value after depreciation.

Find what share of miles are driven empty (unpaid).

Total operating costs over miles — cost per mile, the break-even rate floor.

Empty miles over total miles — deadhead percentage, the empty-mile efficiency metric.

MAX(hours waited − free, 0) times the rate — detention pay for waiting past free time.

MAX of actual weight and volume-over-divisor — billable dimensional weight for freight.

Miles times CPM vs load revenue times percent — compare driver pay models and break-even.

Weight over cubic feet — freight density, the main driver of LTL class.

Fuel over peg divided by MPG — the per-mile fuel surcharge passed to the shipper.

MIN of the 11-hour drive and 14-hour duty limits — HOS drive time remaining.

Load revenue minus all costs — load profit, compared across loads as profit per mile.

On-time deliveries over total — on-time delivery rate, the core carrier service metric.

Load revenue over miles — revenue per mile, the headline trucking rate.

The greater of weight % and cube % — trailer utilization and whether you weigh or cube out.

Start time plus interval-as-day-fraction times reading number — anesthesia monitoring timeline.

Nights between dates times the nightly rate, plus add-ons and discounts — boarding invoice.

Dose/kg/hr times weight times hours, over concentration — drug to add for a CRI.

Dose per kg times weight, over concentration — drug dose and volume to administer.

VLOOKUP a size-to-price table plus add-ons — grooming price by breed size.

Daily volume over 24 for mL/hr; times drip factor over 60 for drops per minute.

Cost times markup plus a dispensing fee, floored at a minimum — client medication price.

A front-loaded IF model — pet age in human years, far better than the ×7 myth.

Completed follow-ups over recommended — recheck compliance, a health and revenue metric.

Revenue over available slots — revenue per slot, split against per-booked to find the fix.

Stock over per-procedure usage (rounded down), then MIN — procedures your supplies allow.

Last dose date plus the interval via EDATE — vaccine booster due dates and reminders.

Days present over enrolled days — attendance rate, feeding ratios, meals, and subsidies.

Calculate required staff and flag rooms that are short.

Total operating cost over enrolled children — cost per child, the tuition break-even benchmark.

Enrolled over licensed capacity — enrollment utilization and the value of open slots.

SUMPRODUCT of meal counts and per-meal rates — CACFP food-program reimbursement.

MAX(minutes late − grace, 0) times the rate — late pickup fees, per minute or per block.

Registration fee plus deposit weeks times weekly tuition — total due at enrollment.

Full tuition for one child, discounted for the rest — the sibling/multi-child discount.

Children over the ratio, rounded up — staff required, with a compliance check.

Tuition minus the capped subsidy — the family copay split for childcare assistance.

Weekly tuition over scheduled days times days attended — prorated childcare tuition.

VLOOKUP an age-group rate table, scaled by schedule — childcare tuition by age.

Enrolled over offered — waitlist conversion, and the offers needed to fill openings.

Annual maximum minus benefit used — remaining dental benefit, capping new claims.

Open chair hours times production per hour — the cost of broken appointments, annualized.

Treatment dollars accepted over presented — case acceptance, a conversion metric.

Full fee minus PPO allowed fee — the contractual write-off and effective plan discount.

Patients with a future visit over active patients — hygiene recare and reactivation.

Allowed fee minus deductible, times coverage % — the dental insurance estimate.

Booked over available chair hours — operatory utilization and the cost of idle chairs.

Fee minus the estimated insurance payment — the patient's out-of-pocket portion.

Collections over production — the collection ratio, a dental practice's cash-health metric.

Overhead plus profit over clinical days — the provider's daily production goal.

SUMPRODUCT of quantities and unit costs — supply cost per procedure and its fee percentage.

PMT on the financed amount — the monthly payment for a financed treatment plan.

Total volume over (ratio + 1) — concentrate needed for a cleaning dilution.

Cleanable square feet times the per-sqft rate — a fast commercial cleaning bid.

Labor hours over the window, rounded up — crew size to finish on time.

Hours times the burdened wage — true cleaning labor cost, the core of any bid.

SUMPRODUCT of room/fixture counts and rates — a per-fixture cleaning quote.

Square feet over the production rate — cleaning hours, the basis of an accurate bid.

Cost over (1 − target margin) — the bid price that guarantees your cleaning margin.

Accounts lost over starting accounts — recurring-account churn and retention.

One-time price less the recurring discount — per-visit and annual recurring value.

Sum of cleaning and drive time across stops — total route hours vs the shift.

SUMPRODUCT of supply quantities and unit costs — supplies cost per cleaning job.

Daily travel cost spread across jobs — travel-time allocation into each bid.

Ownership over annual hours plus operating cost — the all-in equipment hourly rate.

Area in thousands of square feet times the per-1,000 rate — lawn fertilizer or seed pounds.

Cubic yards times tons-per-yard density — gravel and stone tonnage to order.

Target depth over precip rate times 60 — sprinkler zone runtime in minutes.

Mowing time times rate, floored at a minimum — the price per lawn.

Area times depth in feet over 27 — cubic yards of mulch, soil, or compost.

Area plus waste over paver coverage, plus base and sand by volume — patio material counts.

Area over spacing squared — plant count for ground cover, with a triangular-spacing option.

Drive hours over total route hours — drive-time share, the key to route profitability.

Monthly rate times months remaining — seasonal lawn-contract proration.

Base price times a depth-tier multiplier via VLOOKUP — per-push snow removal pricing.

Area plus waste over coverage per piece, rounded up — sod pieces (and pallets) to order.

SUMPRODUCT of chemical amounts and unit costs — chemical cost per service stop.

Volume in 10,000s times ppm increase times the product constant — chlorine dose to raise FC.

Install date plus cycle minus today — days to filter media replacement, plus a pressure trigger.

Gallons moved over minutes — pool flow rate in GPM.

Per-stop cost times monthly visits, marked up to margin — pool service route pricing.

Volume times pH drop times an acid constant — muriatic acid to lower pH.

Gallons times 8.34 times the degree rise — BTUs to heat a pool, and the runtime and cost.

Length times width times average depth times 7.48 — pool volume in gallons.

ppm gap times volume over a constant (floored at zero) — salt to add for a target ppm.

CYA ppm gap times volume over a constant — cyanuric acid stabilizer to add.

Volume over GPM over 60 — pool turnover hours and daily pump runtime.

Nested IF on the saturation index — flag pool water as scaling, balanced, or corrosive.

Conditioned area over sqft-per-ton — a quick AC tonnage estimate (12,000 BTU/ton).

Fuel-per-degree-day times forecast HDD — projected heating fuel use and cost.

Drive labor plus vehicle cost — dispatch cost per call, the floor under the trip charge.

Tons times CFM-per-ton (~400) — required system airflow for duct and blower sizing.

First-visit fixes over total jobs — first-time fix rate, the field-service efficiency metric.

Flat book price vs hours times rate plus parts — compare HVAC pricing models.

Visits times per-visit cost, marked up to margin — HVAC maintenance agreement pricing.

Factory charge plus extra-length adder — refrigerant charge for a longer line set.

Old cost times (1 − old/new SEER) — annual SEER savings and the upgrade payback.

Diagnostic fee plus labor and parts — service call billing, with the diagnostic credited on approval.

Billed hours over paid hours — technician billable efficiency, the labor-profit lever.

Warranty allowance over actual labor cost — recovery rate, often a loss on labor.

Gravity drop (OG − FG) times 131.25 — alcohol by volume from a brew.

Actual over potential gravity points — brewhouse efficiency for grain-bill sizing.

Net ounces over can size, rounded down — sellable cans (or servings) per batch.

Annual fixed costs over operating days — the overhead each day must clear.

Event fixed cost over contribution per cover — break-even customers for a food-truck event.

Alpha acid times ounces times utilization times 7489 over gallons — hop IBU estimate.

Keg cost over pints per keg — cost per pint and pour profit for draft beer.

Plate cost over menu price — food cost %, with target-based pricing.

Burn rate times service hours times price — propane/fuel cost per food-truck event.

Ingredient amount times target-over-recipe yield — scale any recipe to any batch.

Wasted units times unit cost — spoilage and waste cost, plus the waste rate to cut.

Total draft revenue over taps — revenue per tap to manage the lineup.

Weekly rent over profit per cut — haircuts to break even on a rented chair.

Subtract a paid deposit from the quoted price to get the balance due.

IF showed credit the balance, else keep it — deposit forfeiture on a no-show.

Appointments times average ticket, plus booked-over-available occupancy — chair output.

Share a barber's tips with assistants and front desk by percentage.

SUMPRODUCT of disposable quantities and unit costs — supply cost per tattoo session.

Hours times the hourly rate, floored at the shop minimum — tattoo pricing.

Tips times the tip-out percentage, rounded — the apprentice/assistant tip-out.

Add up cup, lid, and sleeve to cost the packaging behind every drink.

Find how many shots a bag of beans yields from your dose.

Find the ingredient cost as a percent of a drink's menu price.

Turn a per-gallon milk price into the milk cost in a single drink.

Work out the effective discount a 'buy 9, get the 10th free' card gives.

Divide labor revenue by hours billed to find your real labor rate.

Charge a percent of labor for shop supplies, capped at a maximum.

Compare parts revenue to labor revenue to gauge your shop's job mix.

Compare flat-rate billed hours to actual clock hours per tech.

Measure repeat repairs as a percentage of total repair orders.

Add a number of minutes to a clock time to find when proofing ends.

Divide batch dough weight by scoop size to count cookies, rounded down.

Base design fee plus servings times per-serving rate, plus optional delivery.

Charge the single-item price under a dozen, the lower each-price at a dozen or more.

Back out the flour weight from total dough and the formula percentage.

Express water as a percentage of flour weight — the baker's hydration ratio.

Divide total dough weight by the weight per piece to get whole units.

Find how many press sheets a job needs when several pieces print per sheet.

Divide total job cost by the number of prints to get a per-piece cost.

Scale a full-coverage ink cost down by the page's ink coverage.

Convert a sheet count into whole reams to pull, rounded up.

Convert booklet pages into folded sheets, four pages per sheet.

Combine a one-time setup charge with a per-piece price for a total quote.

Turn cubic feet into man-hours, then into hours on site for a crew.

Convert cubic feet to estimated weight, then price the move per pound.

Divide total volume by truck capacity and round up to whole trips.

Multiply rented units by the average rate for monthly revenue.

Initial service plus follow-up visits times the visit rate — yearly value.

Work out how much concentrate to add for a tank of a given size.

Turn an annual service plan into the real cost of each visit.

Add a service interval to the last visit to schedule the next one.

A base service fee plus a per-linear-foot rate around the building's perimeter.

Estimate yearly dollar savings from annual production and the utility rate.

Divide monthly production by usage to see how much of the bill solar covers.

Divide array DC watts by inverter AC watts to check the system is sized in the healthy range.

System size times sun hours, days, and a derate factor — monthly kWh.

Convert a kilowatt system size into the number of panels to install.

Divide the net system cost by annual savings to get simple payback.

AVERAGEIF the call log to see each driver's average minutes to scene.

Include a free-mileage radius, then bill only the miles beyond it.

Quote a tow as a flat hookup fee plus a per-mile charge.

Bill at least one day of storage, then a daily rate after that.

See your average ticket when a share of customers take an upsell.

Cost each chemical per car from ounces used, then SUM the stack.

Look up a detail package name and return its price from a rate table.

Find how many washes a month make an unlimited membership pay off.

Quote by the square foot but never below a job minimum.

Estimate on-site hours from the area and your production rate.

Total the individual surface prices, then apply a bundle discount in the same formula.

Multiply your machine's GPM by minutes run to estimate gallons used.

Apply a 1.5x labor multiplier to night and weekend calls with IF.

Multiply keys cut by price per key to track counter revenue.

One trip fee plus a per-lock rekey rate across the whole job.

Quote a job as a trip fee plus labor hours times your rate.

Add dispatch, drive, and on-site minutes to see the wait the customer actually experiences.

Break a total roof bid down to the price per square.

Turn roof squares into shingle bundles, waste included, rounded up.

Convert roof squares into rolls of underlayment, rounded up.

Convert scale-ticket pounds to tons and multiply by the landfill rate.

Charge only the pounds over the included allowance, never a negative amount.

Charge a fraction of the full-truck price, floored at a single-item minimum.

Show how full the truck is as a percent of its capacity.

Price a haul by the fraction of the truck it fills.

Divide units on hand by daily sales, rounded down, to time restocks.

Subtract cost from price and divide by price to get each item's margin.

Multiply gross sales by the agreed rate to find what the host location is owed.

Multiply unit margin by daily sales to see a machine's daily profit.

Compute how many to refill from par level minus current stock.

Credit the paid diagnostic fee against the repair to get the balance due.

Pull a flat repair price from a book-rate table with VLOOKUP.

Bill a diagnostic fee plus labor rounded up to whole half-hour blocks.

Recommend replace when repair tops half the replacement AND the unit is past half its lifespan.

Compare age in months against warranty length so the tech knows who pays before the truck rolls.

Quote interior and exterior panes at separate per-pane rates.

Divide panes cleaned by hours worked to get the production rate you bid future jobs from.

Price the panes and the screens separately, then add the two lines.

Multiply the pane price by a ladder multiplier when the house has upper stories.

Charge the full rate when a student attends, a set percent when they no-show.

Divide a package price by its hours to show the effective hourly rate.

Subtract the hours used from the package to show each student's balance.

Apply a surcharge multiplier to the walk rate only on holidays.

Turn a weekly walk schedule into a monthly invoice amount.

Full rate for the first dog, a discounted rate for each additional dog.

Charge the half-day rate up to four hours, the full-day rate beyond.

Add materials to labor hours times your rate for a quick estimate.

One trip charge plus the sum of every task on the punch list.

Bill dematting in 15-minute blocks, rounded up, on top of the base groom.

FLOOR divides the minutes a groomer is open by the average grooming slot length to show whole appointment slots per day, the base number every booking calendar is built from.

Add the base groom and selected add-ons into one ticket total.

Multiply the run by the slope per foot to find how far a drain line must drop.

One trip fee plus the sum of every fixture install on the visit.

Trip fee covers the first hour; bill extra hours and parts on top.

Multiply each fixture's count by its DFU value and SUM to size the drain.

Divide the total conductor area by the conduit's inside area and flag anything over 40 percent.

Add the circuit loads and divide by the panel rating to see how full a panel is.

Work out the voltage lost over a wire run and express it as a percent of supply voltage.

Price a run as feet of wire times cost per foot, plus labor hours.

Divide the crew's day rate by trees handled to get the cost per tree.

Round chip volume up to whole truckloads, then multiply by the dump fee.

Multiply the stack dimensions for cubic feet, then divide by 128 to get cords.

Price per inch of stump diameter, but never below your minimum.

Turn wash loads per hour and dry time into the number of dryers needed to keep up.

Divide cycles run by machine count — the utilization number laundromats live on.

Add water, electricity, and gas cost into the true utility cost behind one wash.

Price a wash-dry-fold order by the pound, floored at an order minimum.

Convert inches to square feet, price per square foot, floor at a minimum.

Compare the area you actually used against the full sheet to see how much material went in the bin.

A flat setup fee plus a per-character rate for cut vinyl lettering.

Multiply quantity by length, add a waste factor, and round up to whole feet of vinyl.

Turn a measured deposit thickness into an industry Level 1, 2, or 3 rating with nested IFs.

A base sweep for the first flue, a lower rate for each additional flue.

Round gutter footage up to whole debris bags so the truck leaves with enough.

Price gutters by the linear foot, floored at a service minimum.

Divide the section width by the picket face plus its gap, and round up to whole pickets.