Learn one useful thing today.
Fix and Prevent #REF. Errors in VLOOKUP, INDEX, and Structural Edits
Reproduce #REF! when col_index_num or INDEX coordinates exceed table dimensions, guard column bounds dynamically with COLUMNS/ROWS, and prevent broken column counts with MATCH or XLOOKUP.
Read the guide →MathFix floating-point errors: why 1.33 - 1.3 is not 0.03 and how ROUND solves it
Prevent false reconciliation breaks caused by IEEE-754 binary decimals using explicit ROUND(..., 2) or ABS tolerance checks.
Read the guide →Lookup & ReferenceFixed annual date-band lookup: season labels and conventional zodiac bands
Use month/day thresholds for recurring annual categories, including bands crossing January 1.
Read the guide →Financial ModelingFixed-Declining Balance Depreciation (DB Rate, Partial First-Year & Final Stub)
Compute exact fixed-declining balance depreciation rates rounded to 3 decimal places, prorate partial first-year months, and close out final stub periods cleanly.
Read the guide →Logical & ConditionalFlag & Count Values NOT Between X and Y (OR & Two-Tail COUNTIF)
Detect cold-chain, blood-glucose, or machining readings that fall strictly outside an acceptable [Min, Max] window using OR(B2 < MIN(X,Y), B2 > MAX(X,Y)) and count total two-sided excursions via COUNTIF.
Read the guide →StatisticalFlag customers as New vs Returning on every order row
Compare each order date against MINIFS earliest purchase date per customer so unsorted order exports still classify accurately.
Read the guide →LogicalFlag original vs. first duplicate vs. repeat duplicates (Expanding COUNTIF)
Use an expanding range COUNTIF($A$2:A2, A2) to distinguish the 1st valid occurrence (=1), the exact 1st duplicate (=2), and 3rd+ repeats (>2).
Read the guide →LogicalFlag out-of-sequence, skipped, and duplicate invoice or serial numbers
Audit sequential check, voucher, and batch serial logs to classify exact "+1 OK" transitions versus missing-number gaps, duplicates, and reversals.
Read the guide →FinancialFlat add-on interest versus annual cash-flow IRR: a four-payment example
Compare four end-of-year flat-interest payments with a declining-balance loan and calculate the annual IRR of the cash flows.
Read the guide →Statistical & MathFleiss’ Kappa (kappa) Multi-Rater Categorical Agreement Formula
Calculate chance-corrected multi-annotator reliability Fleiss’ Kappa = (P_bar - P_e) / (1 - P_e) across N items rated by n >= 3 raters into k categories for ML data-labeling QA and clinical radiology panels.
Read the guide →StatisticalFlesch Reading Ease & Flesch-Kincaid Grade Level Readability Formulas
Calculate Flesch Reading Ease 206.835 - 1.015*(Words/Sentences) - 84.6*(Syllables/Words) and US school Flesch-Kincaid Grade Level 0.39*(Words/Sentences) + 11.8*(Syllables/Words) - 15.59 for editorial and compliance auditing.
Read the guide →Dynamic Arrays & SpillFlip Table Rows Upside-Down in Exact Reverse Order (SORTBY & SEQUENCE)
Invert any 1D list or multi-column 2D log table from bottom-to-top positional order—even when timestamps have ties or non-chronological text—using SORTBY(range, SEQUENCE(ROWS(range)), -1).
Read the guide →Advanced IC Packaging & Heterogeneous Integration, Flip-Chip C4 Underfill & DNP StrainFlip-Chip C4 DNP Shear Strain & Capillary Underfill Formula
Calculate Corner-Bump CTE Differential Displacement (um), Un-Underfilled Bump Shear Strain (%), Young-Laplace Gap Driving Pressure (kPa), and Washburn-Hele-Shaw Fill Time (s).
Read the guide →Statistical & Clinical AnalysisFLIPI Score for Follicular Lymphoma: Factors and Study Context
Calculate the original five-factor FLIPI total using complete inputs, including the correct age boundary, and interpret risk groups in their research context.
Read the guide →Charts & Visual Data ModelingFloating Bar & Up-Down Column Span Chart Formula: Hidden Base & Positive/Negative Delta
Create Floating Bar (salary bands, temperature ranges) and Up-Down Floating Column charts using stacked series: Hidden Base = MIN(Start, End), Up Gain = MAX(0, End - Start), and Down Loss = MAX(0, Start - End).
Read the guide →Engineering & ScienceFlory-Huggins Polymer Solution Theory: Mixing Free Energy & Critical Chi (chi_c)
Calculate dimensionless Flory-Huggins lattice free energy of mixing Delta_Gm / (n_site * R * T) and the critical spinodal phase-separation parameter chi_c = 0.5 * (1 + 1 / SQRT(N))^2.
Read the guide →Mechanical Energy Storage, Composite Rotordynamics & UPS Grid Frequency RegulationFlywheel Kinetic Energy Storage & Rim Hoop-Stress Formula
Calculate High-Speed Vacuum Flywheel Usable Extractable Kinetic Energy (kWh) Across [RPM_min, RPM_max], Outer-Rim Linear Tip Speed (m/s), Thin-Rim Centrifugal Hoop Stress σ_θ = ρ*v² (MPa), and Composite Burst Safety Factor.
Read the guide →Machine Dynamics, Mechanical Press Flywheels & Rotational InertiaFlywheel Speed Fluctuation (Cs) & Moment of Inertia Formula
Calculate Mean Angular Velocity omega (rad/s), Required Mass Moment of Inertia I (kg·m²) for Target Speed Fluctuation Cs, Equivalent Thin-Rim Mass (kg), and Rim Tip Speed (m/s).
Read the guide →Autonomous Sensing, 77 GHz Automotive FMCW Radar & Signal ProcessingFMCW Radar Chirp Bandwidth, Beat Frequency & Range Formula
Calculate 77 GHz Frequency-Modulated Continuous-Wave (FMCW) Chirp Radar Range Resolution ΔR = c/(2*B), Chirp Slope S (MHz/µs), Target IF Beat Frequency f_b (MHz), and ADC-Limited Maximum Unaliased Detection Range (m).
Read the guide →StatisticalFORECAST function: project a linear trend from historical X and Y pairs
Estimate future demand or utility load along a least-squares linear regression line using FORECAST, and guard against flat X inputs.
Read the guide →FinancialForecast vs Actual Budget Variance: Favorable (F) vs Unfavorable (U)
Build a budget-versus-actual report with an explicit favorable-positive convention, validated account types, zero-base handling and separate amount, percentage and status outputs.
Read the guide →Statistical & MathForest Plot Meta-Analysis: Pooled Effect, 95% CI & Inverse-Variance Weights
Build clinical-trial Forest Plot summary rows by exponentiating log-odds/log-risk effects EXP(theta +/- 1.96 * SE), computing fixed-effect inverse-variance weights w_i = 1 / SE_i^2, and pooling theta_pooled = SUM(w_i * theta_i) / SUM(w_i).
Read the guide →TextFormat email with display name ("Name <email>") and extract address back out
Format a simple single-recipient display string and extract an address from a controlled angle-bracket format. This is not a complete email-header parser.
Read the guide →TextFormat MAC addresses: standardize colons (00:1A:2B...) or Cisco dots
Strip mixed separators from 12-character hex MAC addresses, validate length, and format into colon-separated pairs or Cisco dot-quads.
Read the guide →TextFormat numbers as ordinals: 1st, 2nd, 3rd, 4th (including 11th–13th)
Append accurate English ordinal suffixes ("st", "nd", "rd", "th") to ranks and day numbers while handling the 11th/12th/13th teen exception.
Read the guide →Date & Time FormulasFormula to List Weekend Dates Only (Saturday & Sunday Shift Schedule)
Calculate the upcoming Saturday on or after any start date via B2 + MOD(6 - WEEKDAY(B2, 2), 7) and step strictly across consecutive Saturday/Sunday pairs using 7 * INT((N - 1) / 2) + MOD(N - 1, 2).
Read the guide →Healthcare & Clinical CalculationsForns Index Non-Invasive Liver Fibrosis Calculator (Platelets, GGT, Cholesterol)
Calculate the Forns liver fibrosis index from platelet count, GGT, age and total cholesterol, and understand the original chronic-hepatitis-C study context and thresholds.
Read the guide →Statistical & Clinical AnalysisForrester Hemodynamic Subsets: Cardiac Index and Wedge Pressure
Explore the historical four-subset classification using cardiac output, body surface area, and pulmonary capillary wedge pressure, without turning the result into an automatic diagnosis.
Read the guide →Economics & Market MicrostructureFoster-Greer-Thorbecke (FGT_0, FGT_1, FGT_2) Poverty Headcount, Gap & Severity Formula
Calculate the World Bank’s unified Foster-Greer-Thorbecke (1984) poverty family P_alpha = (1/N) * SUM(MAX(0, (z - y_i)/z)^alpha): Headcount Ratio P_0, Poverty Gap Index P_1, and Distribution-Sensitive Squared Severity P_2.
Read the guide →Foundry Sand Lab & Defect Control, AFS Standard 2-Inch Specimen Permeability FormulaFoundry Green-Sand AFS Permeability & Blowhole Formula
Calculate Volumetric Air Venting Rate (cm³/min), Superficial Darcy Gas Velocity (cm/min), AFS Permeability Number P, and Iron/Steel Castings Steam-Blowhole Gate.
Read the guide →Metal Casting Gating Design, Bernoulli Mold Aspiration Prevention & Pouring TimeFoundry Tapered Sprue Choke & Aspiration Ratio Formula
Calculate Aspiration-Free Top Sprue Entry Area A1 = A2*SQRT(h2/h1) (mm²), Torricelli Choke Velocity (m/s), Volumetric Pouring Rate (cm³/s), and Mold Fill Time (s).
Read the guide →Healthcare & Clinical FormulasFOUR Score: Adding Four Neurological Subscores
Practice adding four fictional 0–4 subscores for the FOUR coma scale, with complete input validation and context about its limits.
Read the guide →EngineeringFourier Heat Conduction formula: composite wall R-Value, U-Value & heat loss (W)
Calculate SI area-normalized resistance, transmittance and signed steady heat flow through a planar layered wall.
Read the guide →Engineering & ScienceFowler-Nordheim Quantum Field-Emission Tunneling Current Density Formula
Calculate cold-cathode quantum electron tunneling current density J = ((1.5414e-6 * E^2) / phi) * EXP((-6.8309e7 * phi^1.5) / E) in A/cm^2 for FE-SEM tips, carbon nanotubes, and flash memory.
Read the guide →Machine Learning & Cluster EvaluationFowlkes-Mallows Clustering Index Formula vs Pairwise F1 and Jaccard
Evaluate clustering partitions in Excel and Arte Sheets using the Fowlkes-Mallows geometric mean of pairwise precision and recall TP / SQRT((TP + FP) * (TP + FN)).
Read the guide →Engineering & ScienceFox Equation & Gordon-Taylor Copolymer Glass Transition Temperature (Tg)
Predict the glass transition temperature Tg (in °C via absolute Kelvin) of random copolymers, plasticized PVC, and miscible amorphous blends using the Fox harmonic rule and Gordon-Taylor equation.
Read the guide →Statistical & PsychometricsFragility Quotient: A Sample-Size Ratio, Not a Trial Verdict
Calculate a percentage from an independently supplied fragility index and a stated sample-size denominator, and understand the limits of interpreting it.
Read the guide →Healthcare & Clinical CalculationsFRAIL Scale: Five Screening Flags in a Spreadsheet
Add five fictional FRAIL screening flags with complete binary-input validation and context about the score’s limits.
Read the guide →Hydropower & Turbomachinery Engineering, Francis Reaction Turbine & Thoma Cavitation LawFrancis Turbine Specific Speed & Thoma Draft-Tube Formula
Calculate Metric Power Specific Speed Ns, Required Runner Suction Head NPSH_r (m), Maximum Safe Runner Elevation Above Tailwater Hs,max (m), and Cavitation Submergence Margin (m).
Read the guide →Engineering & ScienceFranz-Keldysh Electro-Absorption Energy (ħΘ_FK) Modulator Formula
Calculate the Franz-Keldysh photon-assisted tunneling energy ħΘ_FK = 0.72495 * (F^2 / m_r)^(1/3) (meV) governing bulk III-V electro-absorption optical modulators.
Read the guide →EngineeringFree-Space Path Loss (FSPL), Friis RF link power & Inverse-Square dB drop
Calculate wireless RF attenuation FSPL(dB) = 20*LOG10(d_km) + 20*LOG10(f_MHz) + 32.44, Friis received dBm, and acoustic -20*LOG10(d2/d1) distance attenuation.
Read the guide →Statistical & Clinical AnalysisFreedman Log-Rank Sample Size Formula: Required Events ((k*HR + 1)/(HR - 1))²
Calculate conservative log-rank survival event targets under non-null variance using Laurence S. Freedman’s 1982 Statistics in Medicine formula E = ROUNDUP((z_alpha + z_beta)² * (1 + k*HR)² / (k * (1 - HR)²), 0).
Read the guide →Statistical & Clinical AnalysisFrench TMA Score: Two Laboratory Criteria and Limits of Interpretation
Explore the two-point French score described by the French TMA reference center using platelet count and serum creatinine, with explicit units, thresholds and clinical limitations.
Read the guide →LTCC Microelectronics, Glass Frits & SLS Polymer Powders, Yakov Frenkel (1945) Viscous SinteringFrenkel Viscous Sintering Neck Ratio & Shrinkage Formula
Calculate Viscous Capillary Characteristic Time (min), Frenkel Neck-to-Particle Radius Ratio (x/r), Isotropic Linear Shrinkage (-dL/L0 %), and Frenkel-vs-Mackenzie Regime Status.
Read the guide →StatisticalFrequency distribution table: Bin Count, Relative %, and Cumulative %
Group numeric scores into custom bins with COUNTIFS and calculate Relative Frequency % and Cumulative Frequency % without legacy array entry.
Read the guide →StatisticalFREQUENCY function: group numeric values into histogram bins
Count how many observations fall into each upper-bound interval—plus the overflow bin above the highest threshold—using FREQUENCY.
Read the guide →Charts & Visual Data ModelingFrequency Polygon Chart Formula: Class Midpoints, Zero Anchor Bins & Grouped Mean
Construct a true closed Frequency Polygon line/scatter chart: calculate Class Midpoints x_m = (Lower + Upper) / 2, add zero-frequency boundary anchor bins so polygon area equals histogram area, and compute Grouped Mean.
Read the guide →EngineeringFresnel Optical Reflectance, Transmittance & Brewster's Angle formulas
Calculate uncoated glass or crystal surface reflection loss R = ((n1 - n2) / (n1 + n2))^2, single-interface transmittance 1 - R, and Brewster's polarizing angle ATAN(n2 / n1).
Read the guide →Aerospace & EV Battery Tray Solid-State Joining, Friction Stir Welding (FSW) EnergeticsFriction Stir Welding (FSW) Pitch, Heat Index & Power Formula
Calculate FSW Advance-per-Revolution Weld Pitch (mm/rev), Arbegast Pseudo-Heat Index, Mechanical Spindle Stir Power (kW), and Net Linear Heat Input (J/mm).
Read the guide →Chemical, Process & Catalysis EngineeringFriedel Two-Phase Pressure-Drop Multiplier (Phi_LO^2) Formula: Froude & Weber Pipe Flow
Calculate two-phase gas-liquid frictional pressure drop dP_TP = Phi_LO^2 * dP_LO in horizontal and vertical upward pipelines using Lutz Friedel’s (1979) 25,000-point correlation incorporating Froude (Fr_H) and Weber (We_L) numbers.
Read the guide →