Learn one useful thing today.
Case-sensitive lookup with EXACT, XLOOKUP and INDEX/MATCH
Use a per-row EXACT helper to distinguish letter case in text identifiers, with explicit blank and missing-match handling.
Read the guide →Lookup & ReferenceCase-sensitive lookup: match uppercase vs lowercase IDs with EXACT
Combine XLOOKUP or INDEX/MATCH with EXACT when short alphanumeric IDs differ only by letter case.
Read the guide →MathCase-sensitive sum and count with EXACT helper flags
Prevent SUMIF and COUNTIF from merging case-distinct IDs like "001XyzAB" and "001Xyzab" by pairing EXACT with SUMPRODUCT.
Read the guide →Math & TrigCash denomination calculator: break amounts into $100, $50, $20, $10, $5, $1 bills
Compute the minimum number of banknotes for cash envelopes and register drawers using INT and sequential MOD remainders.
Read the guide →FinancialCash-on-Cash Return & Equity Multiple (EMx) formulas in Real Estate
Compute a simplified annual pre-tax cash-on-cash ratio and a realized full-cycle distributions-to-equity multiple, without confusing either with annualized return.
Read the guide →Engineering & ScienceCasimir Effect Quantum Vacuum Pressure (1/d^4) & MEMS Plate Force Formula
Calculate the attractive quantum-electrodynamic Casimir pressure P_C = (PI()^2 * hbar * c) / (240 * d^4) in Pascals and stiction force F_C in microNewtons between parallel uncharged conducting plates separated by d nanometers.
Read the guide →Confectionery Rheology & Food Physics, IOCCC / ICA Casson Chocolate Flow ModelCasson Chocolate Yield Stress & Plastic Viscosity Formula
Calculate IOCCC Casson High-Shear Stress tau (Pa), Apparent Pumping Viscosity (Pa·s), Low-Shear 2 s⁻¹ Gravity-Drain Stress (Pa), and Low-Shear Coating Viscosity (Pa·s).
Read the guide →Insurance-Linked Securities (ILS) & Reinsurance Capital MarketsCatastrophe Bond Spread Multiple & Layer Payout Formula
Calculate ILS Catastrophe Bond Risk-Spread-to-Expected-Loss Multiple, Actuarial Net Excess Spread (bps), Proportional Layer Principal Write-Down Principal * MIN(1, MAX(0, (Loss - Attach)/(Exhaust - Attach))), and Surviving Investor Principal.
Read the guide →Healthcare & ClinicalCATCH Head-Injury Research: Understanding Sensitivity in a Spreadsheet
Calculate sensitivity from fictional counts and read the original CATCH derivation and later validation studies.
Read the guide →TextCategorize bank or expense descriptions by keyword rules
Map noisy merchant strings like "Card #44 UBER *TRIP" into clean accounting categories using IFS, ISNUMBER, and SEARCH.
Read the guide →Engineering & ScienceCauchy Dispersion Equation: Phase Refractive Index n(λ) & Group Index ng(λ)
Calculate visible/near-IR optical phase refractive index n(λ) = A + B/λ^2 + C/λ^4 and ultrafast pulse group index n_g(λ) = n - λ*(dn/dλ) = A + 3B/λ^2 + 5C/λ^4 across wavelength λ (μm).
Read the guide →Engineering & ScienceCaughey-Thomas Doping-Dependent Mobility & Wafer Resistivity (Si)
Calculate semiconductor carrier mobility μ(N) = μ_min + (μ_max - μ_min) / (1 + (N / N_ref)^α) (cm^2/(V·s)) and doped wafer resistivity ρ = 1 / (q * N * μ) across five orders of dopant concentration.
Read the guide →Healthcare & ClinicalCDAI and SDAI: Two Rheumatoid Arthritis Score Examples
Calculate fictional CDAI and SDAI totals from complete joint counts and global ratings, with explicit CRP units and scoring assumptions.
Read the guide →FinancialCDS Credit Triangle Hazard Rate & Cumulative Default Probability formulas
Estimate a constant risk-neutral hazard rate from a spread and assumed recovery, then calculate the corresponding model survival and default probabilities.
Read the guide →Numbers and totalsCEILING.MATH, FLOOR.MATH, and ROUNDDOWN: round to multiples and full units
Round billable minutes up to 15-minute blocks with CEILING.MATH, round stock down to whole pallet multiples with FLOOR.MATH, and count complete dozens with ROUNDDOWN.
Read the guide →Conditional AggregationCell Equals, Count, or Sum One of Many Values (Allowlist COUNTIF + SUMPRODUCT)
Replace brittle 10-way OR chains with a range-driven COUNTIF allowlist flag to test, count, and sum rows matching any value in an editable lookup list.
Read the guide →EngineeringCelsius to Fahrenheit and Kelvin conversion formulas (and back)
Convert temperatures accurately between °C, °F, and Kelvin with exact 9/5 and 5/9 affine formulas.
Read the guide →High-Precision Cylindrical Finishing, Centerless Grinding Regulating Feed & Lobing GeometryCenterless Grinding Through-Feed & Workrest Angle Formula
Calculate Regulating-Wheel Surface Speed (m/min), Axial Through-Feed Rate (mm/min and m/min), and Above-Center Tangency Rounding Angle Beta (deg).
Read the guide →HVAC Energy Retrofits, Variable Frequency Drives (VFDs) & Turbomachinery Fan LawsCentrifugal Fan Affinity Laws & VFD Cubic Power Formula
Calculate VFD Turndown Airflow Q2 (m³/h), Quadratic Static Pressure Delta_P2 (Pa), Cubic Shaft Power P2 (kW), and Annual Fan Energy Savings (kWh/yr).
Read the guide →EngineeringCentrifugal Pump & Fan Affinity Laws: Flow (N), Head (N^2) & Cube Power (N^3)
Explore ideal speed scaling for flow, head and shaft power at corresponding centrifugal-pump operating points.
Read the guide →ScienceCentrifuge RCF (x g) to RPM Conversion Formula & Rotor Scaling
Convert RPM and relative centrifugal force using a specified radius in centimeters. Keep the inverse result unrounded and distinguish a numerical conversion from a permitted instrument setting.
Read the guide →Technical & Sanitaryware Ceramics, Darcy-Washburn Plaster Slip-Casting KineticsCeramic Slip Casting Parabolic Wall-Buildup Formula
Calculate Wet Cast Green Wall Thickness L = SQRT(2*K*t) (mm), Instantaneous Buildup Rate dL/dt (mm/min), Fired Ceramic Wall Thickness (mm), and Dwell Time for 8 mm Cast (min).
Read the guide →Technical Ceramics, Thermoelasticity & High-Temperature MaterialsCeramic Thermal-Shock Resistance R & R-Prime Formula
Calculate Hasselman/Kingery Severe-Quench Critical Delta-T Parameter R (K), Conduction-Weighted Parameter R-Prime (W/m), Biaxial Quench Surface Stress (MPa), and Thermal-Shock Safety Factor.
Read the guide →StatisticalCHA2DS2-VASc score arithmetic with validated flags and age bands
Practice weighted binary flags and mutually exclusive age bands using a fictional CHA2DS2-VASc example; distinguish it from the newer ESC CHA2DS2-VA approach.
Read the guide →Quantitative Finance & TradingChaikin Money Flow (CMF) Formula: Close Location Value Multiplier & Flat-Bar Guard
Calculate Marc Chaikin’s Close Location Value (Money Flow Multiplier) ((C - L) - (H - C)) / (H - L), Money Flow Volume, and 20-period CMF ratio with a halted/flat-bar zero-range guard.
Read the guide →Lookup & ReferenceChained / Nested Two-Step Lookup Across Mapping Tables (XLOOKUP)
Bridge normalized relational tables (such as Employee -> Job Band -> Bonus Target %) in a single formula by nesting one XLOOKUP or VLOOKUP as the lookup_value of a second.
Read the guide →ScienceChandrasekhar Mass Limit & White-Dwarf Radius in a Spreadsheet
Calculate a composition-dependent limiting mass and a Nauenberg-style zero-temperature radius. Keep solar and Earth units explicit, validate the model domain, and avoid treating the limit as a supernova prediction.
Read the guide →Statistical & Clinical AnalysisChao1 & Bias-Corrected Unseen Species Richness Formula: Singletons & Doubletons
Estimate true total assemblage richness (including undetected rare species, software bugs, or vocabulary words) using Anne Chao’s (1984) bias-corrected lower bound S_Chao1 = S_obs + f_1 * (f_1 - 1) / (2 * (f_2 + 1)) and Sample Inventory Completeness %.
Read the guide →Engineering & ScienceChapman-Enskog Low-Pressure Gas Viscosity Formula (Lennard-Jones)
Calculate dilute gas dynamic viscosity μ = 2.6693 * SQRT(M * T) / (σ^2 * Ω_μ) (μPa·s) from molecular weight, absolute temperature, Lennard-Jones collision diameter σ (Å), and collision integral Ω_μ.
Read the guide →TextCHAR and CODE: insert line breaks CHAR(10) and inspect hidden character codes
Generate non-keyboard characters like CHAR(10) line feeds or increment letter sequences with CHAR and CODE.
Read the guide →Healthcare & ClinicalCharlson Comorbidity Research: The 1987 Cohort and Formula
Examine the original age-comorbidity research, its historical cohort and the arithmetic of its theoretical 10-year model.
Read the guide →Statistical & Clinical AnalysisChart Error Bars Formula: Standard Error of the Mean (SEM) vs. SD & 95% CI Bounds
Avoid Excel’s default fixed-value "Standard Error" chart trap by calculating true replicate Standard Error SEM = STDEV(B2:B6) / SQRT(COUNT(B2:B6)) and custom 95% confidence bounds Mean ± 1.96 * SEM.
Read the guide →Math & StatisticalCheck & Count Exact Multiples of a Specific Pack or Lot Size (MOD = 0)
Test whether order quantities are exact multiples of case pack size N using MOD(qty, N) = 0, flag broken-case remainders, and count full-case orders across a table.
Read the guide →LogicalCheck a budget cap, allocation total, and order-pack multiples
Build TRUE/FALSE audit formulas for a budget cap, allocation weights and pack quantities. A formula result alone does not block data entry.
Read the guide →Learn with AICheck an AI forecast in a live workbook before sharing it
Turn a short sales example into a formula-based forecast, label its assumptions and test a changed month. Keep the workbook as the result, not only the chat answer.
Read the guide →EngineeringCheck Baggage Dimensions: Inches to Centimeters and Configurable Limits
Build a spreadsheet dimension check using configurable per-axis and total limits. Convert inches to centimeters and compare unrounded totals without claiming airline approval.
Read the guide →TextCheck if a cell begins or ends with specific text (prefix and suffix)
Test dynamic prefixes with LEFT(text, LEN(prefix)) and suffixes with RIGHT(text, LEN(suffix)), with optional EXACT case sensitivity.
Read the guide →Logical & ConditionalCheck If a Cell Contains a Whole Integer vs. Decimal (ISNUMBER, INT & MOD)
Validate discrete carton quantities, headcount, and serial IDs using AND(ISNUMBER(B2), B2 = INT(B2))—rejecting fractional decimals (4.25), text strings ("12"), and blank cells cleanly.
Read the guide →LogicalCheck if a cell contains all required keywords (and no excluded words)
Screen resumes, logs, or SKUs for ALL required terms, ANY optional term, and ZERO excluded terms using AND, OR, ISNUMBER, ISERROR, and SEARCH.
Read the guide →TextCheck if a cell contains any number (0–9) and count digits
Detect embedded numeric digits inside alphanumeric codes or passwords—where ISNUMBER returns FALSE—by stripping digits 0–9.
Read the guide →Date & TimeCheck If a Date Is a Workday (Exclude Weekends & Holidays)
Check a Monday–Friday work calendar against an explicit list of organization closure dates, with validation for missing dates and timestamp handling.
Read the guide →LogicalCheck if a range contains duplicates (single-cell audit gate)
Compare total non-blank entries against distinct UNIQUE values to trigger a sheet-level duplicate warning and count excess repeat rows.
Read the guide →LogicalCheck if a row is completely blank, complete, or partially filled
Classify rows as blank, Complete or Incomplete with COUNTBLANK and COLUMNS.
Read the guide →Lookup & ReferenceCheck If a Value Exists in a Range (COUNTIF & XMATCH Membership Test)
Check a nonblank ID against an approved list, distinguish literal matching from COUNTIF criteria, and test whether either of two watch-list IDs is present.
Read the guide →LogicalCheck if a value is within a percentage tolerance (±%)
Test symmetric upper and lower tolerance bands in one step with ABS(Measured - Target) / ABS(Target) <= Tolerance.
Read the guide →Date & TimeCheck if a year is a leap year (4 / 100 / 400 Gregorian rule)
Test any year or date for 366-day leap years accurately—including century exceptions like 1900 vs 2000—using MOD or DATE(yr, 2, 29).
Read the guide →Logical & Lookup FormulasCheck if All Cells in a Range Are Blank (COUNTBLANK vs COUNTA)
Test whether an entire row or multi-column block is completely blank using COUNTBLANK(B2:E2) = COLUMNS(B2:E2) (including formula empty strings "") vs strict COUNTA(B2:E2) = 0.
Read the guide →Date & TimeCheck if all dates in a column are in chronological order
Compare offset ranges A2:A4 and A3:A5 inside SUMPRODUCT to verify schedules never step backward and count out-of-order rows.
Read the guide →LogicalCheck if all values in a range are at least a minimum threshold
Verify that every cell in a batch meets a minimum score AND no cell was left blank—avoiding the MIN(range) blank-cell loophole.
Read the guide →TextCheck if cell contains specific words but NOT others (SEARCH, ISNUMBER & NOT)
Match product SKUs, support tickets, or billing descriptions that include required keywords while excluding disqualifying terms like "Trial" or "Refund".
Read the guide →