The functions compute it.
Now the library formats it too.
Fonts, fills, borders, number formats, merged banners, conditional formatting, tables, charts and sparklines — written in the same streaming pass, in pure managed .NET. No Excel install, no COM, no template file.
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
20 functions covering lookups, references, spill anchoring, range trimming, and range/address operations.
Dynamic Array
18 functions for generating, reshaping, filtering, sorting, and combining spilled arrays.
Financial
45 functions covering loans, investments, depreciation, securities, and yield calculations.
Statistical
134 functions covering aggregates, distributions, forecasting, regression, correlation, covariance, rank, hypothesis tests (t / F / z / chi-square), permutations, and legacy compatibility names.
Math & Trig
72 functions covering arithmetic, rounding, powers, factorials, combinatorics, trigonometry and hyperbolics, numeral systems, matrix algebra, series / sum-of-squares, and basic random.
Text
42 functions covering concatenation, substring, search, case, number parsing, value-to-text conversion, and split.
Date & Time
25 functions covering serial dates, business days, ISO weeks, and date math.
Logical
20 functions covering conditionals, boolean operations, error handling, named values, custom functions, and lambda-helper array iteration.
Information
20 functions covering type checks, cell metadata, environment info, error introspection, and sheet info.
Database
12 functions for criteria-based aggregation across structured data tables.
Engineering
50 functions covering unit conversion, base conversion (binary/hex/octal), bitwise operations, error / step functions, and complex number arithmetic.