Blazor Formulas
Evaluate Excel formulas in Blazor and C#. Use them as cell formulas in a workbook, calculate them directly in code, or register your own custom Excel functions. Supports Excel functions including SUM, AVERAGE, IF, VLOOKUP, XLOOKUP, EDATE and SUMIF.
Formulas in code link
Use Excel formulas inside a workbook. Edit any Qty or Price below and every dependent cell recomputes live.
| Product | Qty | Price | Subtotal |
|---|---|---|---|
| Laptop Pro | =B2*C2 → 2400 | ||
| USB Dock | =B3*C3 → 320 | ||
| Wireless Mouse | =B4*C4 → 125 | ||
| Subtotal | =SUM(D2:D4) → 2845 | ||
| Tax (8%) | =D6*0.08 → 227.6 | ||
| Discount (subtotal > $1000) | =IF(D6>1000,-100,0) → -100 | ||
| Total | =D6+D7+D8 → 2972.6 |
Stateless evaluation link
Calculate any Excel formula directly in C# without creating a workbook. Type an expression and get the result.
Stateful evaluation link
Calculate Excel formulas with cell references. Change any input and all dependent formulas recompute automatically.
| Cell | Value |
|---|---|
| A1 | |
| B1 | |
| C1 | =A1+B1 → 5 |
| D1 | =C1*2 → 10 |
Custom functions link
Add your own Excel functions and call them from any cell formula. Below: a custom COMPOUND(principal, rate, years) function for compound interest.
| Context | Formula | Result |
|---|---|---|
| FormulaEngine (headless) | =COMPOUND(1000, 0.05, 3) | 1157.6250000000002 |
| Worksheet.FunctionRegistry | =COMPOUND(A1, B1, C1) | 1157.6250000000002 |
Radzen Blazor Components, © 2018-2026 Radzen.
Source Code licensed under
MIT