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
19 functions covering lookups, references, 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
52 functions covering arithmetic, rounding, powers, factorials, trigonometry, numeral systems, series / sum-of-squares, 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
20 functions covering conditionals, boolean operations, error handling, named values, custom functions, and lambda-helper array iteration.
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
50 functions covering unit conversion, base conversion (binary/hex/octal), bitwise operations, error / step functions, and complex number arithmetic.