Learn one useful thing today.
Lookup a value between two numbers (explicit Min and Max columns)
Match an input inside inclusive [Min, Max] bracket rows using FILTER—rejecting out-of-bounds values that approximate VLOOKUP accepts.
Read the guide →Lookup & ReferenceLookup Across Selectable Rate Tables Without Volatile INDIRECT (IFS & VLOOKUP)
Route SKU price lookups dynamically between Standard and Partner price books based on a customer tier cell using non-volatile IFS and VLOOKUP.
Read the guide →Lookup & ReferenceLookup and sum an entire column or row dynamically (SUM + XLOOKUP)
Match a quarter, month, or scenario header horizontally and SUM, AVERAGE, or MAX the entire matched column in one readable formula.
Read the guide →Financial & Business FormulasLookup Hourly Rates & Sum Total Invoice Billing (XLOOKUP & SUMPRODUCT)
Pull role-based hourly billing rates from a master rate card with XLOOKUP and roll up total project invoice value via SUMPRODUCT(Hours, Looked_Up_Rates).
Read the guide →Lookup & ReferenceLookup Latest File Version, Artifact Filename & Author (XLOOKUP Reverse Search)
Retrieve the most recently appended file revision, version integer, and uploader for any document family in a chronological release log using XLOOKUP search_mode = -1 and MAXIFS.
Read the guide →Lookup & ReferenceLookup latest price or revision by date (unsorted history safe)
Retrieve the most recent unit cost or contract rate for an item even when historical log rows are NOT sorted chronologically.
Read the guide →Lookup & ReferenceLookup price with client-specific contract override and standard rate fallback
Check a negotiated client contract rate table first and automatically fall back to your master catalog price when no custom override exists.
Read the guide →Lookup & ReferenceLookup Product Unit Cost & Extended Gross Profit Without #N/A (XLOOKUP)
Retrieve standard unit cost from a master catalog with built-in XLOOKUP if_not_found protection and compute extended gross profit (Unit_Price - Unit_Cost) * Qty safely.
Read the guide →Lookup & ReferenceLookup the date or name of a MAX or MIN value: first and last matching rows
Return the label associated with a maximum or minimum, and choose the first or last matching row when values tie.
Read the guide →EngineeringLorentz Factor (gamma), Relativistic Time Dilation, Length Contraction & Kinetic Energy
Calculate Hendrik Lorentz & Albert Einstein's relativistic factor gamma = 1 / SQRT(1 - beta^2), dilated coordinate time, contracted length, and (gamma - 1)*mc^2.
Read the guide →Engineering & ScienceLorentz-Lorenz Molar Refractivity (RM) & Clausius-Mossotti Polarizability Formula
Calculate phase-invariant molar refractivity R_M = ((n^2 - 1) / (n^2 + 2)) * (MW / rho) in cm^3/mol and electronic molecular polarizability alpha_0 (in Angstrom^3) from optical refractive index n and density rho.
Read the guide →ScienceLotka-Volterra Equilibrium and Small-Amplitude Period in Excel
Explore predator-prey equilibria, local rates of change and a constant per-capita removal scenario, with a clear distinction between a linearized period and a full nonlinear trajectory.
Read the guide →Private Equity Secondaries, Portfolio Pricing & SPA MechanicsLP Secondary NAV Roll-Forward, Effective Discount & MOIC
Calculate LP Secondary Sale-and-Purchase Agreement (SPA) Closing Price ($M), Effective Closing Discount (%) After Interim Cash Flows, Day-1 Upfront Wire ($M), and Buyer Gross MOIC (x).
Read the guide →Metal Additive Manufacturing, Laser Powder Bed Fusion (LPBF/SLM) & Melt-Pool QALPBF Metal 3D Printing Volumetric Energy Density Formula
Calculate Linear Energy Density P/v (J/mm), Volumetric Energy Density VED = P/(v*h*t) (J/mm³), Theoretical Laser Melt Build Rate (cm³/hr), and Lack-of-Fusion vs Keyhole Porosity Window.
Read the guide →Engineering & ScienceLucas Corresponding-States Low-Pressure Gas Viscosity Formula (µPa·s)
Predict non-polar gas dynamic viscosity η (µPa·s) solely from critical temperature T_c, critical pressure P_c (bar), and molar mass M without Lennard-Jones collision integrals.
Read the guide →Engineering & ScienceLucas-Washburn Capillary Wicking Length & Assay Flow Time
Calculate horizontal capillary penetration distance L(t) = SQRT((γ * r * cos(θ) / (2 * μ)) * t) (mm) and lateral-flow diagnostic transit time t_flow (s) in porous paper strips and heat-pipe wicks.
Read the guide →Engineering & ScienceLuedeking-Piret Bioprocess Kinetics: Growth vs. Non-Growth Product Rate
Calculate specific cellular product formation rate q_p = alpha * mu + beta (g product / g DCW / h) and volumetric bioreactor productivity r_p = (alpha * mu + beta) * X (g/(L*h)) across exponential and stationary fermentation phases.
Read the guide →Math & TrigLuhn Algorithm (Mod 10) formula: generate and validate account check digits
Generate and check a Luhn checksum for an illustrative eight-digit payload. A passing checksum does not validate an account or identity.
Read the guide →EngineeringLumber Board Feet (BF) & MBF pricing formula: (Thick" × Width" × Length') / 12
Convert nominal hardwood and framing tally lists into Board Feet, Linear Feet, and $/MBF (per 1,000 board feet) lumber orders.
Read the guide →Engineering & ScientificLumped-Capacitance Biot Gate (Bi <= 0.1) & Newtonian Thermal Quench Time
Verify lumped-system validity via Characteristic Length L_c = V / A_s and Biot number Bi = h * L_c / k, then calculate thermal time constant tau and exact cooling/heating time.
Read the guide →Clinical Medicine & PhysiologyLund–Browder Charts and Weighted Percentages: A Spreadsheet Exercise
Explore how weighted percentages add up using imaginary regions, and find official resources on burn-size assessment.
Read the guide →Biopharmaceutical Fill-Finish, Freeze-Drying (Lyophilization) & BiologicsLyophilization Primary Drying Vial Sublimation & Time Formula
Calculate Single-Vial Shelf Heat Transfer Input Q_v (W), Ice Sublimation Rate dm/dt (g/hr), Nominal Primary Drying Duration (hr), and Cake Collapse Safety Margin (K).
Read the guide →StatisticalM/M/1 Queueing formula: server utilization, queue length (Lq) & wait time (Wq)
Model call-center, checkout, and API worker queues using M/M/1 arrival rate lambda, service rate mu, utilization rho = lambda/mu, Lq, and Wq.
Read the guide →Operations & LogisticsM/M/1/K Finite-Buffer Queue Blocking Probability, Drop Rate & Mean Occupancy
Model finite-capacity single-server queues (API connection pools, router packet buffers, call trunks) with exact M/M/1/K blocking probability P_K, admitted throughput lambda_eff, mean occupancy L, and rho = 1 singularity handling.
Read the guide →Investment Banking & M&A StructuringM&A Contingent Earnout Sliding-Scale vs Cliff Formula
Calculate Linear Sliding-Scale Earnout Payout E_max * MIN(1, MAX(0, (R_act - R_min) / (R_max - R_min))), Binary All-or-Nothing Cliff Payout, Present-Value Total Consideration, and Marginal Revenue Slope.
Read the guide →Investment Banking & Corporate M&AM&A EPS Accretion / Dilution & Breakeven Synergy Formula
Calculate Pro-Forma M&A Earnings Per Share under mixed stock-and-debt acquisition financing, EPS Accretion/Dilution percentage, and Pre-Tax Breakeven Synergies.
Read the guide →Mergers & Acquisitions, Transaction Advisory & Deal Closing MechanicsM&A EV-to-Equity Bridge, Working Capital Peg & Wire Formula
Calculate M&A Completion-Accounts Closing Net Debt (Debt - Cash), Dollar-for-Dollar Net Working Capital (NWC) Peg Adjustment (Actual_NWC - Target_Peg), Adjusted Equity Purchase Price, and Day-1 Seller Wire Proceeds Net of Escrow.
Read the guide →Investment Banking & M&A StructuringM&A Floating-Value Stock Collar Exchange Ratio Formula
Calculate the floating stock exchange ratio ER = V_offer / MIN(P_cap, MAX(P_floor, P_acq)), implied target per-share payout, and pro-forma target ownership across M&A collar bands.
Read the guide →FinancialMacaulay Duration and Modified Duration Bond Formulas (DURATION & MDURATION)
Compute present-value-weighted cash-flow maturity (Macaulay Duration) and yield sensitivity (Modified Duration) directly from coupon schedules without opaque Analysis ToolPak black boxes.
Read the guide →EngineeringMach Number, Speed of Sound in Air & Aerodynamic Dynamic Pressure (q) formulas
Calculate local speed of sound a = SQRT(1.4 * 287.05 * (T_C + 273.15)), flight Mach Number V / a, compressible regime, and dynamic pressure 0.5 * rho * V^2.
Read the guide →Engineering & ScienceMach-Zehnder Interferometer (MZI): Phase Transmittance & Extinction Ratio
Calculate integrated silicon-photonics Mach-Zehnder bar-port transmittance T = COS(π * Δn_eff * L / λ)^2 and finite coupler Extinction Ratio ER = -20 * LOG10(ABS(1 - 2 * κ)) (dB).
Read the guide →Personal Finance & PlanningMacro-Nutrient Meal & Grocery Budget Planner (SUMPRODUCT Atwater 4-4-9 & Protein Cost)
Scale serving multiples across daily meals with SUMPRODUCT to track total protein, carbs, fats, Atwater 4-4-9 calories, protein calorie share %, and daily grocery budget limits.
Read the guide →Corporate Tax Accounting, CapEx Modeling & Capital BudgetingMACRS 200% DB & IRC §168(k) Bonus Depreciation Formula
Calculate IRC Section 168(k) First-Year Bonus Depreciation ($M), Combined Year-1 MACRS Half-Year 200% Declining-Balance Deduction ($M), Cash Tax Shield ($M), and Adjusted End-of-Year-1 Tax Basis ($M).
Read the guide →OperationsMAE, WAPE & Forecast Bias for Intermittent Zero-Demand SKUs
Measure supply-chain forecast accuracy without #DIV/0! zero-actual explosions using Mean Absolute Error MAE = AVERAGE(|A - F|), Weighted Absolute Percentage Error WAPE = SUM(|A - F|) / SUM(A), and Signed Bias.
Read the guide →Semiconductor PVD & Thin-Film Vacuum Coating, Magnetron Sputtering Rate & Cosine ThrowMagnetron Sputtering PVD Deposition Rate & Throw Formula
Calculate Total Sputtered Atom Emission Rate (10¹⁹ atoms/s), Knudsen Cosine Wafer-Center Flux (10¹⁶ atoms/cm²·s), Film Deposition Rate (nm/min), and 500 nm Seed Coat Time (min).
Read the guide →Operations & LogisticsMaister’s Square-Root Law of Warehouse Centralization & Correlated Safety Stock
Project safety-stock savings when consolidating N_old regional depots into N_new hubs using David Maister’s (1976) SQRT(N_new / N_old) law plus inter-regional demand correlation rho.
Read the guide →TextMake dynamic labels singular or plural based on count (1 item vs 0 items)
Format natural summary strings ("1 pallet", "0 entries", "5 boxes") by testing ABS(Qty) = 1 for regular and irregular nouns.
Read the guide →EngineeringMalus's Law Polarizer Intensity & Brewster's Angle optics formulas
Calculate ideal analyzer transmission and the Brewster angle for two transparent dielectric media.
Read the guide →Health Actuarial & Value-Based Care FinanceManaged Care PMPM Capitation & IBNR Pool Formula
Calculate Risk-Adjusted PMPM Capitation Pool Revenue, Actuarial Completion-Factor Ultimate Incurred Claims (Paid / Completion_Factor), Medical Cost Ratio (MCR), and Net Risk Margin PMPM.
Read the guide →StatisticalMann-Whitney U test (Wilcoxon Rank-Sum) statistic & AUC effect size
Calculate a pooled-rank Mann–Whitney statistic and a descriptive pairwise superiority estimate for two independent groups.
Read the guide →Statistical & Clinical AnalysisMannheim Peritonitis Research: A Weighted Point Sum
Explore the weighted structure of the Mannheim Peritonitis Index and practice adding already-assigned points.
Read the guide →EngineeringManning's Open-Channel Flow formula: hydraulic radius, velocity & discharge Q
Estimate velocity and discharge for a rectangular SI open channel under steady uniform-flow assumptions.
Read the guide →Econometrics & Partial IdentificationManski Worst-Case and Monotone Causal Bounds Formula
Bound Average Treatment Effects without random assignment on bounded [0, 1] or [K_0, K_1] outcomes using Manski’s (1990) worst-case bounds and MTR/MTS tightening.
Read the guide →Statistical & Mathematical FormulasMantel-Haenszel Pooled Odds Ratio: Defeating Simpson’s Paradox
Calculate the confounder-stratified Cochran-Mantel-Haenszel pooled Odds Ratio OR_MH = Σ(a_k * d_k / N_k) / Σ(b_k * c_k / N_k) across multi-center or acuity strata and contrast against biased crude pooled OR.
Read the guide →Lookup & ReferenceMap Likert Survey Text Labels to Numeric Scores (SWITCH vs XLOOKUP Table)
Convert qualitative survey responses ("Strongly Agree" through "Strongly Disagree") or risk ratings into numeric 1–5 weights using SWITCH or an XLOOKUP mapping table, while excluding "N/A" responses from averages.
Read the guide →Logical & Lookup FormulasMap Text Tiers to Arbitrary Numeric Weights (CHOOSE & MATCH vs XLOOKUP)
Assign non-linear SLA severity weights or T-shirt story points ("XS"->1, "S"->2, "M"->5, "L"->8, "XL"->13) to text categories without nested IFs using CHOOSE(MATCH(...)) or XLOOKUP.
Read the guide →Statistical & Clinical AnalysisMargalef Richness, Menhinick Index & Berger-Parker Dominance Formula
Calculate three rapid ecological bioassessment indices from species counts: Margalef Richness D_Mg = (S - 1) / LN(N), Menhinick Richness D_Mn = S / SQRT(N), and Berger-Parker Dominance d_BP = N_max / N (plus reciprocal 1 / d_BP).
Read the guide →Financial ModelingMargrabe Exchange Option Formula & Correlation-Adjusted Spread Volatility
Value a European option to exchange asset 2 for asset 1 (stock-for-stock mergers, outperformance fees, spark spreads) using William Margrabe’s (1978) risk-free-rate-independent formula.
Read the guide →Engineering & ScienceMargules Non-Ideal Liquid Activity Coefficients (gamma1 & gamma2 VLE)
Calculate asymmetric binary vapor-liquid equilibrium (VLE) activity coefficients gamma_1 = EXP((1 - x_1)^2 * (A_12 + 2*(A_21 - A_12)*x_1)) and gamma_2 = EXP(x_1^2 * (A_21 + 2*(A_12 - A_21)*(1 - x_1))) for azeotropic distillation columns.
Read the guide →Charts & Visual Data ModelingMarimekko (Mekko) Chart Formula: Variable Column Widths, Cumulative X-Spans & Cell Area Share
Construct a two-dimensional Marimekko (Mosaic) market-map table: compute Segment Horizontal Width % W_j, Cumulative X-Axis Start/End Coordinates, Within-Segment Vertical Mix %, and Rectangle Area = Grand-Total Market Share.
Read the guide →