Accuracy you can audit
FormulaEngineer doesn't just recognize these functions — it evaluates them to match Excel's own results, down to the last significant digit. Every value is computed in pure .NET, with no Excel install, COM, or interop in the loop.
Supported functions
, organized by family.
Every function below is implemented and tested against real-world workbooks.
Lookup & Reference
17 functions covering lookups, references, and range/address operations.
Dynamic Array
18 functions for generating, reshaping, filtering, sorting, and combining spilled arrays.
Financial
43 functions covering loans, investments, depreciation, securities, and yield calculations.
Statistical
132 functions covering aggregates, distributions, forecasting, regression, correlation, covariance, rank, hypothesis tests (t / F / z / chi-square), permutations, and legacy compatibility names.
Math & Trig
47 functions covering arithmetic, rounding, powers, factorials, trigonometry, numeral systems, and basic random.
Text
40 functions covering concatenation, substring, search, case, number parsing, and split.
Date & Time
25 functions covering serial dates, business days, ISO weeks, and date math.
Logical
13 functions covering conditionals, boolean operations, error handling, named values, and custom functions.
Information
19 functions covering type checks, cell metadata, error introspection, and sheet info.
Database
12 functions for criteria-based aggregation across structured data tables.
Engineering
45 functions covering unit conversion, base conversion (binary/hex/octal), bitwise operations, and complex number arithmetic.