# Documentation

- [Formualizer Documentation](/docs): Build spreadsheet logic once and run it in Rust, Python, and JavaScript/WASM.
- [Dependency Graph and Recalculation](/docs/core-concepts/dependency-graph-and-recalc): Learn how dependency edges drive incremental recomputation.
- [FormulaPlane Span Evaluation](/docs/core-concepts/formula-plane-span-evaluation): Experimental opt-in acceleration for large copied-formula families.
- [Core Concepts](/docs/core-concepts): Mental models for how Formualizer parses formulas, tracks dependencies, and computes values.
- [Named Ranges and Tables](/docs/core-concepts/named-ranges-and-tables): Use semantic references to improve readability and maintainability of formulas.
- [Parse -> AST -> Evaluate -> Workbook](/docs/core-concepts/parse-ast-evaluate-workbook): Understand the execution pipeline from formula text to computed workbook values.
- [Spill Behavior](/docs/core-concepts/spill-behavior): Learn how array-like results expand across cells and when spill conflicts occur.
- [Values, Coercion, and Errors](/docs/core-concepts/values-coercion-and-errors): Understand runtime value types, implicit conversions, and spreadsheet-style error propagation.
- [Circular References and Runtime Cycle Detection](/docs/guides/circular-references-and-cycle-detection): Resolve guarded and routing-switch cycles to values with runtime cycle detection, while real cycles still surface
- [Custom Functions (Rust, Python, JS)](/docs/guides/custom-functions-rust-python-js): Register workbook-local callbacks with consistent semantics across Rust, Python, and JS/WASM.
- [Deterministic Testing](/docs/guides/deterministic-testing): Practical checks and command set for reproducible tests across Rust, Python, and WASM bindings.
- [Guides](/docs/guides): Task-oriented implementation guides for extending and testing Formualizer.
- [Iterative Calculation (Excel Parity)](/docs/guides/iterative-calculation): Enable Excel-style iterative calculation for convergent cycles, accumulators, and self-referential timestamps, with convergence semantics and XLSX calcPr round-trip.
- [Large Workbook Performance](/docs/guides/large-workbook-performance): Practical options for loading and recalculating larger XLSX, JSON, and generated workbooks.
- [LET/LAMBDA and Callables](/docs/guides/let-lambda-and-callables): Current implemented semantics for LET/LAMBDA, including invocation rules, arity, and scope behavior.
- [WASM Plugins: Inspect, Attach, Bind](/docs/guides/wasm-plugins-inspect-attach-bind): Use the Rust workbook plugin seam to inspect manifests, attach modules, and bind exports to worksheet functions.
- [Workbook Edits and Batching](/docs/guides/workbook-edits-and-batching): Use batch writes and action grouping to reduce recalculation churn and keep undo/redo behavior predictable.
- [Architecture at a Glance](/docs/introduction/architecture-at-a-glance): How the Formualizer crates and bindings fit together.
- [Introduction](/docs/introduction): Understand what Formualizer provides, how the workspace is organized, and where to start.
- [Versioning and Stability](/docs/introduction/versioning-and-stability): Practical upgrade guidance for Formualizer crates and bindings.
- [What is Formualizer?](/docs/introduction/what-is-formualizer): Formualizer is a cross-runtime spreadsheet engine with workbook APIs for Rust, Python, and WASM.
- [Why Formualizer?](/docs/introduction/why-formualizer): Why teams choose Formualizer for spreadsheet logic in production systems.
- [Formula Sandbox](/docs/playground/formula-sandbox): Evaluate formulas quickly with controlled inputs and inspect outputs/errors.
- [Playground](/docs/playground): Interactive sandbox docs for trying formulas, parser output, and grid behavior.
- [Mini Grid Sandbox](/docs/playground/mini-grid-sandbox): A lightweight spreadsheet-like environment for testing formulas.
- [Parser + AST Inspector](/docs/playground/parser-ast-inspector): Inspect tokens, parse diagnostics, and AST output for a formula expression.
- [First Workbook in 5 Minutes](/docs/quickstarts/first-workbook-in-5-minutes): End-to-end mini-flow: write inputs, set formula, evaluate output.
- [Quickstarts](/docs/quickstarts): Copy/paste starters for Rust, Python, and JavaScript/WASM.
- [JavaScript/WASM Quickstart](/docs/quickstarts/js-wasm-quickstart): Initialize the WASM module and evaluate workbook formulas from JS.
- [Pyodide Quickstart](/docs/quickstarts/pyodide-quickstart): Run formualizer in the browser via Pyodide — install with micropip and evaluate workbook formulas client-side.
- [Python Quickstart](/docs/quickstarts/python-quickstart): Install formualizer, build a workbook, and evaluate formulas from Python.
- [Rust Quickstart](/docs/quickstarts/rust-quickstart): Create a workbook, set cells, evaluate a formula, and read the result in Rust.
- [Cycle Configuration Reference](/docs/reference/cycle-config): The CycleConfig surface — detection modes, policies, iterative-calculation knobs, and how it maps across Rust, Python, and JS/WASM.
- [Errors and Types](/docs/reference/errors-and-types): Detailed guide on value types, coercion rules, and error handling in Formualizer.
- [Reference Overview](/docs/reference): API maps, generated function reference, parser utility, and error/type guides for Formualizer.
- [JS/WASM API Reference](/docs/reference/js-wasm-api-map): Comprehensive documentation for the Formualizer JavaScript and WebAssembly bindings.
- [Python API Reference](/docs/reference/python-api-map): Comprehensive documentation for the Formualizer Python bindings.
- [Rust API Map](/docs/reference/rust-api-map): Detailed overview of the Rust crates and core types in the Formualizer workspace.
- [SheetPort](/docs/sheetport): Treat spreadsheets as deterministic, typed functions.
- [Manifest Format (FIO Spec)](/docs/sheetport/manifest-format): Complete reference for the SheetPort YAML manifest format.
- [SheetPort Quickstart](/docs/sheetport/quickstart): End-to-end example of using SheetPort in Rust, Python, and JS/WASM.
- [Sessions and Evaluation](/docs/sheetport/sessions-and-evaluation): How SheetPortSession manages state, evaluation options, and batch execution.
- [What Is SheetPort?](/docs/sheetport/what-is-sheetport): Understand the core concepts of the SheetPort I/O layer.
- [Function Reference](/docs/reference/functions): Generated function documentation backed by Rust source metadata and examples.
- [DAVERAGE](/docs/reference/functions/database/daverage): DAVERAGE: Returns the arithmetic mean of values in a database field for matching records.
- [DCOUNT](/docs/reference/functions/database/dcount): DCOUNT: Counts numeric cells in a database field for records matching criteria.
- [DCOUNTA](/docs/reference/functions/database/dcounta): DCOUNTA: Counts non-blank values in a database field for records matching criteria.
- [DGET](/docs/reference/functions/database/dget): DGET: Returns a single field value from the only record that matches criteria.
- [DMAX](/docs/reference/functions/database/dmax): DMAX: Returns the largest value in a database field for records matching criteria.
- [DMIN](/docs/reference/functions/database/dmin): DMIN: Returns the smallest value in a database field for records matching criteria.
- [DPRODUCT](/docs/reference/functions/database/dproduct): DPRODUCT: Multiplies values in a database field for records that satisfy criteria.
- [DSTDEV](/docs/reference/functions/database/dstdev): DSTDEV: Returns the sample standard deviation of a database field for matching records.
- [DSTDEVP](/docs/reference/functions/database/dstdevp): DSTDEVP: Returns the population standard deviation of a database field for matching records.
- [DSUM](/docs/reference/functions/database/dsum): DSUM: Sums values in a database field for records that match criteria.
- [DVAR](/docs/reference/functions/database/dvar): DVAR: Returns the sample variance of a database field for records matching criteria.
- [DVARP](/docs/reference/functions/database/dvarp): DVARP: Returns the population variance of a database field for records matching criteria.
- [Database Functions](/docs/reference/functions/database): Generated reference pages for Database functions.
- [DATE](/docs/reference/functions/datetime/date): Returns the serial number for a calendar date from year, month, and day.
- [DATEDIF](/docs/reference/functions/datetime/datedif): DATEDIF: Returns the difference between two dates in a requested unit.
- [DATEVALUE](/docs/reference/functions/datetime/datevalue): DATEVALUE: Parses a date string and returns its date serial number.
- [DAY](/docs/reference/functions/datetime/day): Extracts the day-of-month (`1` to `31`) from a date serial.
- [DAYS](/docs/reference/functions/datetime/days): Returns the number of whole days between two date serial values.
- [DAYS360](/docs/reference/functions/datetime/days360): DAYS360: Returns the day count between two dates using a 30/360 convention.
- [EDATE](/docs/reference/functions/datetime/edate): EDATE: Returns the serial date offset by a whole number of months from a start date.
- [EOMONTH](/docs/reference/functions/datetime/eomonth): EOMONTH: Returns the serial for the last day of the month at a month offset from a start date.
- [HOUR](/docs/reference/functions/datetime/hour): Extracts the hour component (`0` to `23`) from a time or datetime serial.
- [Date & Time Functions](/docs/reference/functions/datetime): Generated reference pages for Date & Time functions.
- [ISOWEEKNUM](/docs/reference/functions/datetime/isoweeknum): ISOWEEKNUM: Returns the ISO 8601 week number (`1` to `53`) for a date serial.
- [MINUTE](/docs/reference/functions/datetime/minute): Extracts the minute component (`0` to `59`) from a time or datetime serial.
- [MONTH](/docs/reference/functions/datetime/month): Extracts the month number (`1` to `12`) from a date serial.
- [NETWORKDAYS.INTL](/docs/reference/functions/datetime/networkdays-intl): NETWORKDAYS.INTL: Returns the number of working days between two dates with configurable weekends.
- [NETWORKDAYS](/docs/reference/functions/datetime/networkdays): NETWORKDAYS: Returns the number of weekday business days between two dates, inclusive.
- [NOW](/docs/reference/functions/datetime/now): NOW: Returns the current date and time as a volatile datetime serial.
- [SECOND](/docs/reference/functions/datetime/second): Extracts the second component (`0` to `59`) from a time or datetime serial.
- [TIME](/docs/reference/functions/datetime/time): Returns the fractional-day serial for a time built from hour, minute, and second.
- [TIMEVALUE](/docs/reference/functions/datetime/timevalue): TIMEVALUE: Parses a time string and returns its fractional-day serial value.
- [TODAY](/docs/reference/functions/datetime/today): TODAY: Returns the current date as a volatile serial value.
- [WEEKDAY](/docs/reference/functions/datetime/weekday): WEEKDAY: Returns the day-of-week index for a date serial with configurable numbering.
- [WEEKNUM](/docs/reference/functions/datetime/weeknum): WEEKNUM: Returns the week number of the year for a date serial.
- [WORKDAY.INTL](/docs/reference/functions/datetime/workday-intl): WORKDAY.INTL: Returns the date serial that is a given number of workdays from a start date, with configurable weekends.
- [WORKDAY](/docs/reference/functions/datetime/workday): WORKDAY: Returns the date serial that is a given number of weekdays from a start date.
- [YEAR](/docs/reference/functions/datetime/year): Extracts the calendar year from a date serial.
- [YEARFRAC](/docs/reference/functions/datetime/yearfrac): YEARFRAC: Returns the fraction of a year between two dates for a selected day-count basis.
- [ACCRINT](/docs/reference/functions/financial/accrint): ACCRINT: Returns accrued interest for a coupon-bearing security.
- [ACCRINTM](/docs/reference/functions/financial/accrintm): ACCRINTM: Returns accrued interest for a security that pays interest at maturity.
- [CUMIPMT](/docs/reference/functions/financial/cumipmt): CUMIPMT: Returns cumulative interest paid between two inclusive payment periods.
- [CUMPRINC](/docs/reference/functions/financial/cumprinc): CUMPRINC: Returns cumulative principal paid between two inclusive payment periods.
- [DB](/docs/reference/functions/financial/db): DB: Returns fixed-declining-balance depreciation for a specified period.
- [DDB](/docs/reference/functions/financial/ddb): DDB: Returns declining-balance depreciation for a period using a configurable acceleration factor.
- [DOLLARDE](/docs/reference/functions/financial/dollarde): DOLLARDE: Converts fractional-dollar notation into a decimal dollar value.
- [DOLLARFR](/docs/reference/functions/financial/dollarfr): DOLLARFR: Converts a decimal dollar value into fractional-dollar notation.
- [EFFECT](/docs/reference/functions/financial/effect): Converts a nominal annual rate into an effective annual rate.
- [FV](/docs/reference/functions/financial/fv): FV: Calculates future value from a fixed periodic rate and payment stream.
- [Financial Functions](/docs/reference/functions/financial): Generated reference pages for Financial functions.
- [IPMT](/docs/reference/functions/financial/ipmt): IPMT: Returns the interest-only component of a payment for a specific period.
- [IRR](/docs/reference/functions/financial/irr): IRR: Calculates periodic internal rate of return for regularly spaced cash flows.
- [ISPMT](/docs/reference/functions/financial/ispmt): ISPMT: Returns the interest paid on the outstanding principal for a specific period of an investment with even principal payments. Calculates interest paid in a per…
- [MIRR](/docs/reference/functions/financial/mirr): MIRR: Calculates modified internal rate of return with separate finance and reinvest rates.
- [NOMINAL](/docs/reference/functions/financial/nominal): Converts an effective annual rate into a nominal annual rate.
- [NPER](/docs/reference/functions/financial/nper): NPER: Calculates the number of periods needed to satisfy a cash-flow target.
- [NPV](/docs/reference/functions/financial/npv): NPV: Calculates net present value for equally spaced cash flows.
- [PDURATION](/docs/reference/functions/financial/pduration): PDURATION: Returns the number of periods required for an investment to reach a specified future value at a constant interest rate.
- [PMT](/docs/reference/functions/financial/pmt): PMT: Calculates the constant payment amount for a fixed-rate annuity or loan.
- [PPMT](/docs/reference/functions/financial/ppmt): PPMT: Returns the principal component of a payment for a specific period.
- [PRICE](/docs/reference/functions/financial/price): Returns clean price per 100 face value for a coupon-paying security.
- [PV](/docs/reference/functions/financial/pv): PV: Calculates present value from periodic cash flows at a fixed rate.
- [RATE](/docs/reference/functions/financial/rate): Solves for the periodic interest rate implied by annuity cash flows.
- [RRI](/docs/reference/functions/financial/rri): RRI(nper, pv, fv) — equivalent interest rate for growth of an investment. Returns (fv/pv)^(1/nper) - 1 (i.e. CAGR).
- [SLN](/docs/reference/functions/financial/sln): SLN: Returns straight-line depreciation for a single period.
- [SYD](/docs/reference/functions/financial/syd): SYD: Returns sum-of-years'-digits depreciation for a requested period.
- [TBILLEQ](/docs/reference/functions/financial/tbilleq): TBILLEQ: Returns bond-equivalent yield for a US Treasury bill.
- [TBILLPRICE](/docs/reference/functions/financial/tbillprice): TBILLPRICE: Returns price per $100 face value for a US Treasury bill.
- [TBILLYIELD](/docs/reference/functions/financial/tbillyield): TBILLYIELD: Returns the yield for a US Treasury bill.
- [XIRR](/docs/reference/functions/financial/xirr): XIRR: Calculates annualized internal rate of return for irregularly dated cash flows.
- [XNPV](/docs/reference/functions/financial/xnpv): XNPV: Calculates annualized net present value for irregularly dated cash flows.
- [YIELD](/docs/reference/functions/financial/yield): Returns annual yield for a coupon-paying security from its market price.
- [BESSELI](/docs/reference/functions/engineering/besseli): BESSELI: Returns the modified Bessel function In(x).
- [BESSELJ](/docs/reference/functions/engineering/besselj): BESSELJ: Returns the Bessel function Jn(x).
- [BESSELK](/docs/reference/functions/engineering/besselk): BESSELK: Returns the modified Bessel function Kn(x).
- [BESSELY](/docs/reference/functions/engineering/bessely): BESSELY: Returns the Bessel function Yn(x).
- [BIN2DEC](/docs/reference/functions/engineering/bin2dec): BIN2DEC: Converts a binary text value to decimal.
- [BIN2HEX](/docs/reference/functions/engineering/bin2hex): BIN2HEX: Converts a binary text value to hexadecimal text.
- [BIN2OCT](/docs/reference/functions/engineering/bin2oct): BIN2OCT: Converts a binary text value to octal text.
- [BITAND](/docs/reference/functions/engineering/bitand): BITAND: Returns the bitwise AND of two non-negative integers.
- [BITLSHIFT](/docs/reference/functions/engineering/bitlshift): BITLSHIFT: Shifts a non-negative integer left or right by a given bit count.
- [BITOR](/docs/reference/functions/engineering/bitor): BITOR: Returns the bitwise OR of two non-negative integers.
- [BITRSHIFT](/docs/reference/functions/engineering/bitrshift): BITRSHIFT: Shifts a non-negative integer right or left by a given bit count.
- [BITXOR](/docs/reference/functions/engineering/bitxor): BITXOR: Returns the bitwise exclusive OR of two non-negative integers.
- [COMPLEX](/docs/reference/functions/engineering/complex): Builds a complex number text value from real and imaginary coefficients.
- [CONVERT](/docs/reference/functions/engineering/convert): Converts a numeric value from one supported unit to another.
- [DEC2BIN](/docs/reference/functions/engineering/dec2bin): DEC2BIN: Converts a decimal integer to binary text.
- [DEC2HEX](/docs/reference/functions/engineering/dec2hex): DEC2HEX: Converts a decimal integer to hexadecimal text.
- [DEC2OCT](/docs/reference/functions/engineering/dec2oct): DEC2OCT: Converts a decimal integer to octal text.
- [DELTA](/docs/reference/functions/engineering/delta): DELTA: Tests whether two numbers are equal.
- [ERF.PRECISE](/docs/reference/functions/engineering/erf-precise): ERF.PRECISE: Returns the error function of a number.
- [ERF](/docs/reference/functions/engineering/erf): ERF: Returns the Gaussian error function over one bound or between two bounds.
- [ERFC.PRECISE](/docs/reference/functions/engineering/erfc-precise): ERFC.PRECISE: Returns the complementary error function of a number.
- [ERFC](/docs/reference/functions/engineering/erfc): ERFC: Returns the complementary error function of a number.
- [GESTEP](/docs/reference/functions/engineering/gestep): GESTEP: Returns `1` when a number is greater than or equal to a step value.
- [HEX2BIN](/docs/reference/functions/engineering/hex2bin): HEX2BIN: Converts a hexadecimal text value to binary text.
- [HEX2DEC](/docs/reference/functions/engineering/hex2dec): HEX2DEC: Converts a hexadecimal text value to decimal.
- [HEX2OCT](/docs/reference/functions/engineering/hex2oct): HEX2OCT: Converts a hexadecimal text value to octal text.
- [IMABS](/docs/reference/functions/engineering/imabs): IMABS: Returns the modulus (absolute value) of a complex number.
- [IMAGINARY](/docs/reference/functions/engineering/imaginary): Returns the imaginary coefficient of a complex number.
- [IMARGUMENT](/docs/reference/functions/engineering/imargument): IMARGUMENT: Returns the argument (angle in radians) of a complex number.
- [IMCONJUGATE](/docs/reference/functions/engineering/imconjugate): IMCONJUGATE: Returns the complex conjugate of a complex number.
- [IMCOS](/docs/reference/functions/engineering/imcos): IMCOS: Returns the cosine of a complex number.
- [IMCOSH](/docs/reference/functions/engineering/imcosh): IMCOSH: Returns the hyperbolic cosine of a complex number.
- [IMCOT](/docs/reference/functions/engineering/imcot): IMCOT: Returns the cotangent of a complex number.
- [IMCSC](/docs/reference/functions/engineering/imcsc): IMCSC: Returns the cosecant of a complex number.
- [IMCSCH](/docs/reference/functions/engineering/imcsch): IMCSCH: Returns the hyperbolic cosecant of a complex number.
- [IMDIV](/docs/reference/functions/engineering/imdiv): IMDIV: Returns the quotient of two complex numbers.
- [IMEXP](/docs/reference/functions/engineering/imexp): IMEXP: Returns the complex exponential of a complex number.
- [IMLN](/docs/reference/functions/engineering/imln): IMLN: Returns the natural logarithm of a complex number.
- [IMLOG10](/docs/reference/functions/engineering/imlog10): IMLOG10: Returns the base-10 logarithm of a complex number.
- [IMLOG2](/docs/reference/functions/engineering/imlog2): IMLOG2: Returns the base-2 logarithm of a complex number.
- [IMPOWER](/docs/reference/functions/engineering/impower): IMPOWER: Raises a complex number to a real power.
- [IMPRODUCT](/docs/reference/functions/engineering/improduct): IMPRODUCT: Returns the product of one or more complex numbers.
- [IMREAL](/docs/reference/functions/engineering/imreal): IMREAL: Returns the real coefficient of a complex number.
- [IMSEC](/docs/reference/functions/engineering/imsec): IMSEC: Returns the secant of a complex number.
- [IMSECH](/docs/reference/functions/engineering/imsech): IMSECH: Returns the hyperbolic secant of a complex number.
- [IMSIN](/docs/reference/functions/engineering/imsin): IMSIN: Returns the sine of a complex number.
- [IMSINH](/docs/reference/functions/engineering/imsinh): IMSINH: Returns the hyperbolic sine of a complex number.
- [IMSQRT](/docs/reference/functions/engineering/imsqrt): IMSQRT: Returns the principal square root of a complex number.
- [IMSUB](/docs/reference/functions/engineering/imsub): IMSUB: Returns the difference between two complex numbers.
- [IMSUM](/docs/reference/functions/engineering/imsum): IMSUM: Returns the sum of one or more complex numbers.
- [IMTAN](/docs/reference/functions/engineering/imtan): IMTAN: Returns the tangent of a complex number.
- [Engineering Functions](/docs/reference/functions/engineering): Generated reference pages for Engineering functions.
- [OCT2BIN](/docs/reference/functions/engineering/oct2bin): OCT2BIN: Converts an octal text value to binary text.
- [OCT2DEC](/docs/reference/functions/engineering/oct2dec): OCT2DEC: Converts an octal text value to decimal.
- [OCT2HEX](/docs/reference/functions/engineering/oct2hex): OCT2HEX: Converts an octal text value to hexadecimal text.
- [LET / LAMBDA Functions](/docs/reference/functions/lambda): Generated reference pages for LET / LAMBDA functions.
- [LAMBDA](/docs/reference/functions/lambda/lambda): LAMBDA: Creates an anonymous callable that can be invoked with spreadsheet arguments.
- [LET](/docs/reference/functions/lambda/let): LET: Binds local names to values and evaluates a final expression with those bindings.
- [ERROR.TYPE](/docs/reference/functions/info/error-type): ERROR.TYPE: Returns a number corresponding to an error type Returns: 1 = #NULL! 2 = #DIV/0! 3 = #VALUE! 4 = #REF! 5 = #NAME? 6 = #NUM! 7 = #N/A 8 = #GETTING_DATA (n…
- [FORMULATEXT](/docs/reference/functions/info/formulatext): FORMULATEXT: Returns the formula text stored in the referenced cell.
- [Information Functions](/docs/reference/functions/info): Generated reference pages for Information functions.
- [ISBLANK](/docs/reference/functions/info/isblank): ISBLANK: Returns TRUE only for a truly empty value.
- [ISERR](/docs/reference/functions/info/iserr): ISERR: Returns TRUE for any error except `#N/A`.
- [ISERROR](/docs/reference/functions/info/iserror): ISERROR: Returns TRUE for any error value.
- [ISEVEN](/docs/reference/functions/info/iseven): ISEVEN: Returns TRUE if number is even.
- [ISFORMULA](/docs/reference/functions/info/isformula): ISFORMULA: Returns whether a value originates from a formula.
- [ISLOGICAL](/docs/reference/functions/info/islogical): ISLOGICAL: Returns TRUE when the value is a boolean.
- [ISNA](/docs/reference/functions/info/isna): ISNA: Returns TRUE only for the `#N/A` error.
- [ISNONTEXT](/docs/reference/functions/info/isnontext): ISNONTEXT: Returns TRUE when the value is anything other than text.
- [ISNUMBER](/docs/reference/functions/info/isnumber): ISNUMBER: Returns TRUE when the value is numeric.
- [ISODD](/docs/reference/functions/info/isodd): ISODD: Returns TRUE if number is odd.
- [ISREF](/docs/reference/functions/info/isref): ISREF: Returns TRUE when the argument resolves to a reference.
- [ISTEXT](/docs/reference/functions/info/istext): ISTEXT: Returns TRUE when the value is text.
- [N](/docs/reference/functions/info/n): Converts a value to its numeric representation.
- [NA](/docs/reference/functions/info/na): NA: Returns the `#N/A` error value.
- [SHEET](/docs/reference/functions/info/sheet): Returns the 1-based sheet index for the current sheet or a reference.
- [SHEETS](/docs/reference/functions/info/sheets): Returns the number of sheets in the workbook or reference span.
- [T](/docs/reference/functions/info/t): Returns text when input is text, otherwise returns empty text.
- [TYPE](/docs/reference/functions/info/type): Returns an Excel TYPE code describing the value category.
- [AND](/docs/reference/functions/logical/and): AND: Returns TRUE only when all supplied values evaluate to TRUE.
- [FALSE](/docs/reference/functions/logical/false): Returns the logical constant FALSE.
- [IF](/docs/reference/functions/logical/if): IF: Returns one value when a condition is TRUE and another when FALSE.
- [Logical Functions](/docs/reference/functions/logical): Generated reference pages for Logical functions.
- [OR](/docs/reference/functions/logical/or): OR: Returns TRUE when any supplied value evaluates to TRUE.
- [TRUE](/docs/reference/functions/logical/true): Returns the logical constant TRUE.
- [IFERROR](/docs/reference/functions/logical-ext/iferror): IFERROR: Returns a fallback when the first expression evaluates to any error.
- [IFNA](/docs/reference/functions/logical-ext/ifna): IFNA: Returns a fallback only when the first expression is `#N/A`.
- [IFS](/docs/reference/functions/logical-ext/ifs): IFS: Returns the value for the first TRUE condition in condition-value pairs.
- [Logical (Extended) Functions](/docs/reference/functions/logical-ext): Generated reference pages for Logical (Extended) functions.
- [NOT](/docs/reference/functions/logical-ext/not): NOT: Reverses the logical value of its argument.
- [SWITCH](/docs/reference/functions/logical-ext/switch): SWITCH: Returns the result corresponding to the first matching candidate value.
- [XOR](/docs/reference/functions/logical-ext/xor): XOR: Returns TRUE when an odd number of arguments evaluate to TRUE.
- [Random Functions](/docs/reference/functions/random): Generated reference pages for Random functions.
- [RAND](/docs/reference/functions/random/rand): Returns a uniformly distributed pseudo-random number in the interval `[0, 1)`.
- [RANDBETWEEN](/docs/reference/functions/random/randbetween): RANDBETWEEN: Returns a random integer between two inclusive bounds.
- [INDEX](/docs/reference/functions/reference-fns/index-fn): INDEX: Returns the value or reference at a 1-based row and column within an array or range.
- [Reference Functions](/docs/reference/functions/reference-fns): Generated reference pages for Reference functions.
- [INDIRECT](/docs/reference/functions/reference-fns/indirect): INDIRECT: Converts text into a reference and returns the referenced value or range.
- [OFFSET](/docs/reference/functions/reference-fns/offset): OFFSET: Returns a reference shifted from a starting reference by rows and columns.
- [ADDRESS](/docs/reference/functions/lookup/address): ADDRESS: Returns a cell reference as text from row and column numbers.
- [CHOOSE](/docs/reference/functions/lookup/choose): CHOOSE: Returns one value from a list using a 1-based index.
- [CHOOSECOLS](/docs/reference/functions/lookup/choosecols): CHOOSECOLS: Returns selected columns from an array or range.
- [CHOOSEROWS](/docs/reference/functions/lookup/chooserows): CHOOSEROWS: Returns selected rows from an array or range.
- [COLUMN](/docs/reference/functions/lookup/column): Returns the column number of a reference, or of the current cell when omitted.
- [COLUMNS](/docs/reference/functions/lookup/columns): Returns the number of columns in a reference or array.
- [DROP](/docs/reference/functions/lookup/drop): DROP: Removes rows and optional columns from the start or end of an array.
- [FILTER](/docs/reference/functions/lookup/filter): Filters rows from an array using a Boolean include mask.
- [GROUPBY](/docs/reference/functions/lookup/groupby): GROUPBY: Groups rows by key fields and returns aggregated values as a spilled table.
- [HLOOKUP](/docs/reference/functions/lookup/hlookup): HLOOKUP: Looks up a value in the first row of a table and returns a value from another row.
- [HSTACK](/docs/reference/functions/lookup/hstack): HSTACK: Concatenates arrays horizontally into a single spilled array.
- [Lookup Functions](/docs/reference/functions/lookup): Generated reference pages for Lookup functions.
- [LOOKUP](/docs/reference/functions/lookup/lookup): LOOKUP: Searches for a value and returns a corresponding value from another range.
- [MATCH](/docs/reference/functions/lookup/match): MATCH: Returns the relative position of a lookup value in a one-dimensional array.
- [PIVOTBY](/docs/reference/functions/lookup/pivotby): PIVOTBY: Builds a pivot-style summary matrix from row fields, column fields, and values.
- [RANDARRAY](/docs/reference/functions/lookup/randarray): RANDARRAY: Generates a random spilled array of numbers.
- [ROW](/docs/reference/functions/lookup/row): Returns the row number of a reference, or of the current cell when omitted.
- [ROWS](/docs/reference/functions/lookup/rows): Returns the number of rows in a reference or array.
- [SEQUENCE](/docs/reference/functions/lookup/sequence): SEQUENCE: Generates a sequential numeric array with configurable size, start, and step.
- [SORT](/docs/reference/functions/lookup/sort): Sorts an array by a selected row or column and returns a spilled result.
- [SORTBY](/docs/reference/functions/lookup/sortby): SORTBY: Sorts an array based on one or more aligned sort-by arrays.
- [TAKE](/docs/reference/functions/lookup/take): TAKE: Returns a subset from the start or end of rows and optional columns.
- [TOCOL](/docs/reference/functions/lookup/tocol): TOCOL: Converts an array or range into a single column.
- [TOROW](/docs/reference/functions/lookup/torow): TOROW: Converts an array or range into a single row.
- [TRANSPOSE](/docs/reference/functions/lookup/transpose): TRANSPOSE: Swaps rows and columns in an input range.
- [UNIQUE](/docs/reference/functions/lookup/unique): UNIQUE: Returns distinct rows or columns from a range.
- [VLOOKUP](/docs/reference/functions/lookup/vlookup): VLOOKUP: Looks up a value in the first column of a table and returns a value from another column.
- [VSTACK](/docs/reference/functions/lookup/vstack): VSTACK: Concatenates arrays vertically into a single spilled array.
- [XLOOKUP](/docs/reference/functions/lookup/xlookup): XLOOKUP: Looks up a value in one array and returns the aligned value from another array.
- [XMATCH](/docs/reference/functions/lookup/xmatch): XMATCH: Returns the 1-based position of a value in a one-dimensional lookup array.
- [ARRAYTOTEXT](/docs/reference/functions/text/arraytotext): ARRAYTOTEXT: Converts an array or range into a text representation.
- [ASC](/docs/reference/functions/text/asc): Converts full-width Latin and ASCII characters to half-width text.
- [CHAR](/docs/reference/functions/text/char): Returns the character specified by a number Excel uses Windows-1252 encoding for codes 1-255.
- [CLEAN](/docs/reference/functions/text/clean): CLEAN: Removes non-printable ASCII control characters from text.
- [CODE](/docs/reference/functions/text/code): Returns a numeric code for the first character in a text string.
- [CONCAT](/docs/reference/functions/text/concat): Concatenates multiple values into one text string.
- [CONCATENATE](/docs/reference/functions/text/concatenate): CONCATENATE: Legacy alias for `CONCAT` that joins multiple values as text.
- [DOLLAR](/docs/reference/functions/text/dollar): DOLLAR: Formats a number as currency text.
- [EXACT](/docs/reference/functions/text/exact): Compares two text values for exact equality.
- [FIND](/docs/reference/functions/text/find): FIND: Returns the 1-based position of one text string inside another.
- [FINDB](/docs/reference/functions/text/findb): FINDB: Finds text within text using non-DBCS byte-compatible semantics.
- [FIXED](/docs/reference/functions/text/fixed): Formats a number as text with fixed decimal places.
- [Text Functions](/docs/reference/functions/text): Generated reference pages for Text functions.
- [LEFT](/docs/reference/functions/text/left): Returns the leftmost characters from a text value.
- [LEFTB](/docs/reference/functions/text/leftb): LEFTB: Returns the leftmost characters using non-DBCS byte-compatible semantics.
- [LEN](/docs/reference/functions/text/len): LEN: Returns the number of characters in a text value.
- [LENB](/docs/reference/functions/text/lenb): LENB: Returns text length using non-DBCS byte-compatible semantics.
- [LOWER](/docs/reference/functions/text/lower): Converts text to lowercase.
- [MID](/docs/reference/functions/text/mid): MID: Returns a substring starting at a 1-based position.
- [MIDB](/docs/reference/functions/text/midb): MIDB: Extracts text from the middle using non-DBCS byte-compatible semantics.
- [NUMBERVALUE](/docs/reference/functions/text/numbervalue): NUMBERVALUE: Converts locale-delimited text to a number.
- [PROPER](/docs/reference/functions/text/proper): PROPER: Capitalizes the first letter of each alphanumeric word.
- [REPLACE](/docs/reference/functions/text/replace): Replaces part of a text string by position.
- [REPLACEB](/docs/reference/functions/text/replaceb): REPLACEB: Replaces text using non-DBCS byte-compatible semantics.
- [REPT](/docs/reference/functions/text/rept): REPT: Repeats text a given number of times.
- [RIGHT](/docs/reference/functions/text/right): Returns the rightmost characters from a text value.
- [RIGHTB](/docs/reference/functions/text/rightb): RIGHTB: Returns the rightmost characters using non-DBCS byte-compatible semantics.
- [SEARCH](/docs/reference/functions/text/search): SEARCH: Returns the 1-based position of one text string inside another.
- [SEARCHB](/docs/reference/functions/text/searchb): SEARCHB: Searches text using non-DBCS byte-compatible semantics.
- [SUBSTITUTE](/docs/reference/functions/text/substitute): SUBSTITUTE: Replaces matching text within a string.
- [TEXT](/docs/reference/functions/text/text): Formats a value as text using a format pattern.
- [TEXTAFTER](/docs/reference/functions/text/textafter): TEXTAFTER: Returns text that appears after a delimiter.
- [TEXTBEFORE](/docs/reference/functions/text/textbefore): TEXTBEFORE: Returns text that appears before a delimiter.
- [TEXTJOIN](/docs/reference/functions/text/textjoin): TEXTJOIN: Joins text values using a delimiter, with optional empty-value filtering.
- [TEXTSPLIT](/docs/reference/functions/text/textsplit): TEXTSPLIT: Splits text into a dynamic 2D array by column and optional row delimiters.
- [TRIM](/docs/reference/functions/text/trim): TRIM: Removes leading/trailing whitespace and collapses internal runs to single spaces.
- [UNICHAR](/docs/reference/functions/text/unichar): UNICHAR: Returns the Unicode character for a given code point.
- [UNICODE](/docs/reference/functions/text/unicode): Returns the Unicode code point of the first character in text.
- [UPPER](/docs/reference/functions/text/upper): Converts text to uppercase.
- [VALUE](/docs/reference/functions/text/value): Converts text that represents a number into a numeric value.
- [VALUETOTEXT](/docs/reference/functions/text/valuetotext): VALUETOTEXT: Converts a value to text representation.
- [ABS](/docs/reference/functions/math/abs): Returns the absolute value of a number.
- [ACOS](/docs/reference/functions/math/acos): ACOS: Returns the angle in radians whose cosine is the input value.
- [ACOSH](/docs/reference/functions/math/acosh): ACOSH: Returns the inverse hyperbolic cosine of a number.
- [ACOT](/docs/reference/functions/math/acot): ACOT: Returns the angle in radians whose cotangent is the input value.
- [ACOTH](/docs/reference/functions/math/acoth): ACOTH: Returns the inverse hyperbolic cotangent of a number.
- [AGGREGATE](/docs/reference/functions/math/aggregate): Reference for the AGGREGATE function.
- [ARABIC](/docs/reference/functions/math/arabic): Converts a Roman numeral string to its Arabic numeric value.
- [ASIN](/docs/reference/functions/math/asin): ASIN: Returns the angle in radians whose sine is the input value.
- [ASINH](/docs/reference/functions/math/asinh): ASINH: Returns the inverse hyperbolic sine of a number.
- [ATAN](/docs/reference/functions/math/atan): ATAN: Returns the angle in radians whose tangent is the input value.
- [ATAN2](/docs/reference/functions/math/atan2): ATAN2: Returns the arctangent of `y/x`, preserving quadrant information.
- [ATANH](/docs/reference/functions/math/atanh): ATANH: Returns the inverse hyperbolic tangent of a number.
- [AVERAGE](/docs/reference/functions/math/average): AVERAGE: Returns the arithmetic mean of numeric values across scalars and ranges.
- [AVERAGEIF](/docs/reference/functions/math/averageif): AVERAGEIF: Returns the average of cells that satisfy a single criterion.
- [AVERAGEIFS](/docs/reference/functions/math/averageifs): AVERAGEIFS: Returns the average of cells that satisfy multiple criteria.
- [BASE](/docs/reference/functions/math/base): BASE: Converts a non-negative integer to text in the requested radix.
- [CEILING.MATH](/docs/reference/functions/math/ceiling-math): Rounds a number up to the nearest integer or multiple using `CEILING.MATH` rules.
- [CEILING.PRECISE](/docs/reference/functions/math/ceiling-precise): CEILING.PRECISE: Rounds a number up toward positive infinity using absolute significance.
- [CEILING](/docs/reference/functions/math/ceiling): CEILING: Rounds a number up to the nearest multiple of a significance.
- [COMBIN](/docs/reference/functions/math/combin): Returns the number of combinations for selecting `k` items from `n`.
- [COMBINA](/docs/reference/functions/math/combina): Returns the number of combinations with repetition.
- [COS](/docs/reference/functions/math/cos): Returns the cosine of an angle in radians.
- [COSH](/docs/reference/functions/math/cosh): COSH: Returns the hyperbolic cosine of a number.
- [COT](/docs/reference/functions/math/cot): Returns the cotangent of an angle, defined as `1 / TAN(angle)`.
- [COTH](/docs/reference/functions/math/coth): COTH: Returns the hyperbolic cotangent of a number, defined as `COSH(x) / SINH(x)`.
- [COUNT](/docs/reference/functions/math/count): Counts numeric values across scalars and ranges.
- [COUNTA](/docs/reference/functions/math/counta): COUNTA: Counts non-empty cells and scalar arguments.
- [COUNTBLANK](/docs/reference/functions/math/countblank): COUNTBLANK: Counts blank cells, including empty-string text results.
- [COUNTIF](/docs/reference/functions/math/countif): COUNTIF: Counts cells in a range that satisfy a single criterion.
- [COUNTIFS](/docs/reference/functions/math/countifs): COUNTIFS: Counts cells that satisfy all supplied criteria pairs.
- [CSC](/docs/reference/functions/math/csc): CSC: Returns the cosecant of an angle, defined as `1 / SIN(angle)`.
- [CSCH](/docs/reference/functions/math/csch): CSCH: Returns the hyperbolic cosecant of a number, defined as `1 / SINH(x)`.
- [DECIMAL](/docs/reference/functions/math/decimal): Converts text in a given radix back to a decimal number.
- [DEGREES](/docs/reference/functions/math/degrees): Converts an angle from radians to degrees.
- [EVEN](/docs/reference/functions/math/even): Rounds a number away from zero to the nearest even integer.
- [EXP](/docs/reference/functions/math/exp): EXP: Returns Euler's number `e` raised to the given power.
- [FACT](/docs/reference/functions/math/fact): Returns the factorial of a non-negative integer.
- [FACTDOUBLE](/docs/reference/functions/math/factdouble): FACTDOUBLE: Returns the double factorial of a number.
- [FLOOR.MATH](/docs/reference/functions/math/floor-math): Rounds a number down to the nearest integer or multiple using `FLOOR.MATH` rules.
- [FLOOR.PRECISE](/docs/reference/functions/math/floor-precise): FLOOR.PRECISE: Rounds a number down toward negative infinity using absolute significance.
- [FLOOR](/docs/reference/functions/math/floor): FLOOR: Rounds a number down to the nearest multiple of a significance.
- [GCD](/docs/reference/functions/math/gcd): GCD: Returns the greatest common divisor of one or more integers.
- [Math Functions](/docs/reference/functions/math): Generated reference pages for Math functions.
- [INT](/docs/reference/functions/math/int): Rounds a number down to the nearest integer.
- [ISO.CEILING](/docs/reference/functions/math/iso-ceiling): ISO.CEILING: Rounds a number up using ISO ceiling semantics.
- [LCM](/docs/reference/functions/math/lcm): LCM: Returns the least common multiple of one or more integers.
- [LN](/docs/reference/functions/math/ln): LN: Returns the natural logarithm of a positive number.
- [LOG](/docs/reference/functions/math/log): Returns the logarithm of a number for a specified base.
- [LOG10](/docs/reference/functions/math/log10): LOG10: Returns the base-10 logarithm of a positive number.
- [MAX](/docs/reference/functions/math/max): MAX: Returns the largest numeric value from one or more arguments.
- [MIN](/docs/reference/functions/math/min): MIN: Returns the smallest numeric value from one or more arguments.
- [MOD](/docs/reference/functions/math/mod): MOD: Returns the remainder after division, with the sign of the divisor.
- [MROUND](/docs/reference/functions/math/mround): MROUND: Rounds a number to the nearest multiple.
- [MULTINOMIAL](/docs/reference/functions/math/multinomial): Returns the multinomial coefficient for one or more values.
- [ODD](/docs/reference/functions/math/odd): Rounds a number away from zero to the nearest odd integer.
- [PERMUT](/docs/reference/functions/math/permut): Returns the number of permutations for selecting and ordering `k` items from `n`.
- [PI](/docs/reference/functions/math/pi): PI: Returns the mathematical constant π.
- [POWER](/docs/reference/functions/math/power): Raises a base number to a specified power.
- [QUOTIENT](/docs/reference/functions/math/quotient): QUOTIENT: Returns the integer portion of a division result, truncated toward zero.
- [RADIANS](/docs/reference/functions/math/radians): Converts an angle from degrees to radians.
- [ROMAN](/docs/reference/functions/math/roman): Converts an Arabic number to a Roman numeral string.
- [ROUND](/docs/reference/functions/math/round): Rounds a number to a specified number of digits.
- [ROUNDDOWN](/docs/reference/functions/math/rounddown): ROUNDDOWN: Rounds a number toward zero to a specified number of digits.
- [ROUNDUP](/docs/reference/functions/math/roundup): ROUNDUP: Rounds a number away from zero to a specified number of digits.
- [SEC](/docs/reference/functions/math/sec): Returns the secant of an angle, defined as `1 / COS(angle)`.
- [SECH](/docs/reference/functions/math/sech): SECH: Returns the hyperbolic secant of a number, defined as `1 / COSH(x)`.
- [SERIESSUM](/docs/reference/functions/math/seriessum): SERIESSUM: Evaluates a power series from coefficients, start power, and step.
- [SIGN](/docs/reference/functions/math/sign): Returns the sign of a number as -1, 0, or 1.
- [SIN](/docs/reference/functions/math/sin): Returns the sine of an angle in radians.
- [SINH](/docs/reference/functions/math/sinh): SINH: Returns the hyperbolic sine of a number.
- [SQRT](/docs/reference/functions/math/sqrt): SQRT: Returns the positive square root of a number.
- [SQRTPI](/docs/reference/functions/math/sqrtpi): SQRTPI: Returns the square root of a number multiplied by pi.
- [SUBTOTAL](/docs/reference/functions/math/subtotal): Reference for the SUBTOTAL function.
- [SUM](/docs/reference/functions/math/sum): SUM: Adds numeric values across scalars and ranges.
- [SUMIF](/docs/reference/functions/math/sumif): SUMIF: Adds values that satisfy a single criterion.
- [SUMIFS](/docs/reference/functions/math/sumifs): SUMIFS: Adds values that satisfy multiple criteria.
- [SUMPRODUCT](/docs/reference/functions/math/sumproduct): SUMPRODUCT: Multiplies aligned values across arrays and returns the sum of those products.
- [SUMSQ](/docs/reference/functions/math/sumsq): SUMSQ: Returns the sum of squares of supplied numbers.
- [SUMX2MY2](/docs/reference/functions/math/sumx2my2): SUMX2MY2: Returns the sum of squares of values in one array minus the squares in another.
- [SUMX2PY2](/docs/reference/functions/math/sumx2py2): SUMX2PY2: Returns the sum of squares of corresponding values from two arrays.
- [SUMXMY2](/docs/reference/functions/math/sumxmy2): SUMXMY2: Returns the sum of squared differences between corresponding values.
- [TAN](/docs/reference/functions/math/tan): Returns the tangent of an angle in radians.
- [TANH](/docs/reference/functions/math/tanh): TANH: Returns the hyperbolic tangent of a number.
- [TRUNC](/docs/reference/functions/math/trunc): Truncates a number toward zero, optionally at a specified digit position.
- [AVEDEV](/docs/reference/functions/stats/avedev): AVEDEV: Returns the average of absolute deviations from the mean.
- [AVERAGEA](/docs/reference/functions/stats/averagea): AVERAGEA: Returns the arithmetic mean while treating logical values and text as numeric inputs.
- [BETA.DIST](/docs/reference/functions/stats/beta-dist): BETA.DIST: Returns the beta-distribution probability for `x`, with optional lower/upper bounds.
- [BETA.INV](/docs/reference/functions/stats/beta-inv): BETA.INV: Returns the inverse cumulative beta distribution, optionally scaled to custom bounds.
- [BINOM.DIST.RANGE](/docs/reference/functions/stats/binom-dist-range): BINOM.DIST.RANGE: Returns the probability that a binomial random variable falls within a range of successes.
- [BINOM.DIST](/docs/reference/functions/stats/binom-dist): BINOM.DIST: Returns the binomial probability for a count of successes across independent trials.
- [BINOM.INV](/docs/reference/functions/stats/binom-inv): BINOM.INV: Returns the smallest number of successes whose cumulative binomial probability meets a threshold.
- [CHISQ.DIST.RT](/docs/reference/functions/stats/chisq-dist-rt): CHISQ.DIST.RT: Returns the right-tailed chi-squared distribution probability.
- [CHISQ.DIST](/docs/reference/functions/stats/chisq-dist): CHISQ.DIST: Returns the chi-square probability for `x` with the specified degrees of freedom.
- [CHISQ.INV.RT](/docs/reference/functions/stats/chisq-inv-rt): CHISQ.INV.RT: Returns the inverse of the right-tailed chi-squared distribution.
- [CHISQ.INV](/docs/reference/functions/stats/chisq-inv): CHISQ.INV: Returns the chi-square value whose left-tail probability is `probability`.
- [CHISQ.TEST](/docs/reference/functions/stats/chisq-test): CHISQ.TEST: Returns the right-tail p-value from a chi-square goodness-of-fit style comparison.
- [CONFIDENCE.NORM](/docs/reference/functions/stats/confidence-norm): CONFIDENCE.NORM: Returns the half-width of a confidence interval using a normal critical value.
- [CONFIDENCE.T](/docs/reference/functions/stats/confidence-t): CONFIDENCE.T: Returns the half-width of a confidence interval using a t critical value.
- [CORREL](/docs/reference/functions/stats/correl): Returns the Pearson correlation coefficient between two numeric arrays.
- [COVARIANCE.P](/docs/reference/functions/stats/covariance-p): COVARIANCE.P: Returns population covariance for two paired numeric data sets.
- [COVARIANCE.S](/docs/reference/functions/stats/covariance-s): COVARIANCE.S: Returns sample covariance for two paired numeric data sets.
- [DEVSQ](/docs/reference/functions/stats/devsq): DEVSQ: Returns the sum of squared deviations from the mean.
- [EXPON.DIST](/docs/reference/functions/stats/expon-dist): EXPON.DIST: Returns the exponential-distribution probability at `x` for rate `lambda`.
- [F.DIST.RT](/docs/reference/functions/stats/f-dist-rt): F.DIST.RT: Returns the right-tailed F-distribution probability.
- [F.DIST](/docs/reference/functions/stats/f-dist): F.DIST: Returns the F-distribution probability for `x` with numerator and denominator degrees of freedom.
- [F.INV.RT](/docs/reference/functions/stats/f-inv-rt): F.INV.RT: Returns the inverse of the right-tailed F-distribution.
- [F.INV](/docs/reference/functions/stats/f-inv): F.INV: Returns the F value whose left-tail probability equals `probability`.
- [F.TEST](/docs/reference/functions/stats/f-test): F.TEST: Returns the two-tailed p-value from an F-test comparing sample variances.
- [FISHER](/docs/reference/functions/stats/fisher): Returns the Fisher z-transformation of a correlation-like value `x`.
- [FISHERINV](/docs/reference/functions/stats/fisherinv): FISHERINV: Returns the inverse Fisher transformation of `y`.
- [FORECAST.LINEAR](/docs/reference/functions/stats/forecast-linear): FORECAST.LINEAR: Returns a predicted y-value at `x` from simple linear regression over known data.
- [FREQUENCY](/docs/reference/functions/stats/frequency): Returns a vertical frequency distribution for numeric data across bin cutoffs.
- [GAMMA.DIST](/docs/reference/functions/stats/gamma-dist): GAMMA.DIST: Returns the gamma-distribution probability at `x` for shape `alpha` and scale `beta`.
- [GAMMA.INV](/docs/reference/functions/stats/gamma-inv): GAMMA.INV: Returns the inverse cumulative gamma distribution.
- [GAMMA](/docs/reference/functions/stats/gamma): Returns the value of the gamma function.
- [GAMMALN.PRECISE](/docs/reference/functions/stats/gammaln-precise): GAMMALN.PRECISE: Returns the natural logarithm of the gamma function using Excel's precise naming variant.
- [GAMMALN](/docs/reference/functions/stats/gammaln): GAMMALN: Returns the natural logarithm of the gamma function.
- [GAUSS](/docs/reference/functions/stats/gauss): GAUSS: Returns the standard normal area between `0` and `z`.
- [GEOMEAN](/docs/reference/functions/stats/geomean): GEOMEAN: Returns the geometric mean of positive numeric values.
- [GROWTH](/docs/reference/functions/stats/growth): GROWTH: Returns fitted values from an exponential trend model.
- [HARMEAN](/docs/reference/functions/stats/harmean): HARMEAN: Returns the harmonic mean of positive numeric values.
- [HYPGEOM.DIST](/docs/reference/functions/stats/hypgeom-dist): HYPGEOM.DIST: Returns hypergeometric probabilities for successes drawn without replacement.
- [Statistics Functions](/docs/reference/functions/stats): Generated reference pages for Statistics functions.
- [INTERCEPT](/docs/reference/functions/stats/intercept): Returns the y-intercept of the linear regression line for paired data.
- [KURT](/docs/reference/functions/stats/kurt): Returns the sample excess kurtosis of a numeric distribution.
- [LARGE](/docs/reference/functions/stats/large): Returns the k-th largest value in a data set.
- [LINEST](/docs/reference/functions/stats/linest): LINEST: Returns linear-regression coefficients and optional fit statistics.
- [LOGEST](/docs/reference/functions/stats/logest): LOGEST: Returns parameters for an exponential model fitted to known data.
- [LOGNORM.DIST](/docs/reference/functions/stats/lognorm-dist): LOGNORM.DIST: Returns the log-normal probability at `x` as either a cumulative value or density.
- [LOGNORM.INV](/docs/reference/functions/stats/lognorm-inv): LOGNORM.INV: Returns the positive value `x` whose log-normal cumulative probability is `probability`.
- [MAXA](/docs/reference/functions/stats/maxa): MAXA: Returns the largest value after applying A-variant coercion rules.
- [MAXIFS](/docs/reference/functions/stats/maxifs): MAXIFS: Returns the maximum numeric value in a range that meets all criteria.
- [MEDIAN](/docs/reference/functions/stats/median): MEDIAN: Returns the middle value of a numeric data set.
- [MINA](/docs/reference/functions/stats/mina): MINA: Returns the smallest value after applying A-variant coercion rules.
- [MINIFS](/docs/reference/functions/stats/minifs): MINIFS: Returns the minimum numeric value in a range that meets all criteria.
- [MODE.MULT](/docs/reference/functions/stats/mode-mult): MODE.MULT: Returns all modal values as a vertical array.
- [MODE.SNGL](/docs/reference/functions/stats/mode-sngl): MODE.SNGL: Returns the most frequently occurring value in a data set.
- [NEGBINOM.DIST](/docs/reference/functions/stats/negbinom-dist): NEGBINOM.DIST: Returns negative-binomial probabilities for failures observed before a target success count.
- [NORM.DIST](/docs/reference/functions/stats/norm-dist): NORM.DIST: Returns the normal-distribution probability at `x` for a given mean and standard deviation.
- [NORM.INV](/docs/reference/functions/stats/norm-inv): NORM.INV: Returns the value `x` whose normal cumulative probability equals `probability`.
- [NORM.S.DIST](/docs/reference/functions/stats/norm-s-dist): NORM.S.DIST: Returns the standard normal probability for a z-score as either a CDF or PDF value.
- [NORM.S.INV](/docs/reference/functions/stats/norm-s-inv): NORM.S.INV: Returns the z-score whose standard normal cumulative probability matches `probability`.
- [PEARSON](/docs/reference/functions/stats/pearson): Returns the Pearson correlation coefficient between two paired numeric arrays.
- [PERCENTILE.EXC](/docs/reference/functions/stats/percentile-exc): PERCENTILE.EXC: Returns the k-th percentile of a data set using exclusive interpolation.
- [PERCENTILE.INC](/docs/reference/functions/stats/percentile-inc): PERCENTILE.INC: Returns the k-th percentile of a data set using inclusive interpolation.
- [PERCENTRANK.EXC](/docs/reference/functions/stats/percentrank-exc): PERCENTRANK.EXC: Returns the exclusive percentile rank of `x` within a numeric data array.
- [PERCENTRANK.INC](/docs/reference/functions/stats/percentrank-inc): PERCENTRANK.INC: Returns the inclusive percentile rank of `x` within a numeric data array.
- [PHI](/docs/reference/functions/stats/phi): PHI: Returns the standard normal probability density at `x`.
- [POISSON.DIST](/docs/reference/functions/stats/poisson-dist): POISSON.DIST: Returns the Poisson probability for event count `x` at average rate `mean`.
- [PRODUCT](/docs/reference/functions/stats/product): Multiplies all numeric arguments and returns their product.
- [QUARTILE.EXC](/docs/reference/functions/stats/quartile-exc): QUARTILE.EXC: Returns an exclusive quartile value for a data set.
- [QUARTILE.INC](/docs/reference/functions/stats/quartile-inc): QUARTILE.INC: Returns an inclusive quartile value for a data set.
- [RANK.AVG](/docs/reference/functions/stats/rank-avg): RANK.AVG: Returns the rank position of a number, averaging the rank positions for ties.
- [RANK.EQ](/docs/reference/functions/stats/rank-eq): RANK.EQ: Returns the rank position of a number within a data set, with ties sharing the same rank.
- [RSQ](/docs/reference/functions/stats/rsq): RSQ: Returns the coefficient of determination (`R^2`) for paired x/y data.
- [SKEW.P](/docs/reference/functions/stats/skew-p): SKEW.P: Returns the population skewness of a numeric data set.
- [SKEW](/docs/reference/functions/stats/skew): Returns the sample skewness of a numeric distribution.
- [SLOPE](/docs/reference/functions/stats/slope): Returns the slope of the linear regression line for paired data.
- [SMALL](/docs/reference/functions/stats/small): Returns the k-th smallest value in a data set.
- [STANDARDIZE](/docs/reference/functions/stats/standardize): STANDARDIZE: Returns the z-score of `x` relative to a mean and standard deviation.
- [STDEV.P](/docs/reference/functions/stats/stdev-p): STDEV.P: Returns population standard deviation using `n` in the denominator.
- [STDEV.S](/docs/reference/functions/stats/stdev-s): STDEV.S: Estimates sample standard deviation using `n-1` in the denominator.
- [STDEVA](/docs/reference/functions/stats/stdeva): STDEVA: Returns the sample standard deviation using A-variant coercion semantics.
- [STDEVPA](/docs/reference/functions/stats/stdevpa): STDEVPA: Returns the population standard deviation using A-variant coercion semantics.
- [STEYX](/docs/reference/functions/stats/steyx): STEYX: Returns the standard error of y-estimates from a simple linear regression.
- [T.DIST.2T](/docs/reference/functions/stats/t-dist-2t): T.DIST.2T: Returns the two-tailed Student's t probability beyond `x`.
- [T.DIST.RT](/docs/reference/functions/stats/t-dist-rt): T.DIST.RT: Returns the right-tailed Student's t-distribution probability.
- [T.DIST](/docs/reference/functions/stats/t-dist): T.DIST: Returns the Student's t probability for `x` and a given degrees-of-freedom value.
- [T.INV.2T](/docs/reference/functions/stats/t-inv-2t): T.INV.2T: Returns the positive t critical value for a two-tailed probability.
- [T.INV](/docs/reference/functions/stats/t-inv): T.INV: Returns the t-value whose left-tail probability equals `probability`.
- [T.TEST](/docs/reference/functions/stats/t-test): T.TEST: Returns the p-value from a Student t-test comparing two numeric samples.
- [TREND](/docs/reference/functions/stats/trend): Returns fitted y-values along a linear trend derived from known data.
- [TRIMMEAN](/docs/reference/functions/stats/trimmean): TRIMMEAN: Returns the mean after trimming a percentage of values from both tails.
- [VAR.P](/docs/reference/functions/stats/var-p): VAR.P: Returns population variance using `n` in the denominator.
- [VAR.S](/docs/reference/functions/stats/var-s): VAR.S: Estimates sample variance using `n-1` in the denominator.
- [VARA](/docs/reference/functions/stats/vara): VARA: Returns the sample variance using A-variant coercion semantics.
- [VARPA](/docs/reference/functions/stats/varpa): VARPA: Returns the population variance using A-variant coercion semantics.
- [WEIBULL.DIST](/docs/reference/functions/stats/weibull-dist): WEIBULL.DIST: Returns the Weibull-distribution probability at `x` for shape `alpha` and scale `beta`.
- [Z.TEST](/docs/reference/functions/stats/z-test): Z.TEST: Returns the one-tailed p-value of a z-test against hypothesized mean `x`.