🔗 Integrationsadvanced6 min read
Supported Excel Formulas in Unsheet — Complete Function Reference
Full list of 400+ Excel functions supported by Unsheet's HyperFormula engine. SUM, IF, VLOOKUP, INDEX/MATCH, and more — all recalculate live.
Most Common Functions
| Function | Description | Example |
|---|---|---|
SUM | Add numbers | =SUM(B2:B10) |
AVERAGE | Calculate mean | =AVERAGE(C2:C50) |
IF | Conditional logic | =IF(B2>100,"High","Low") |
VLOOKUP | Vertical lookup | =VLOOKUP(A2,Sheet2!A:B,2,FALSE) |
COUNT | Count numbers | =COUNT(A2:A100) |
COUNTIF | Conditional count | =COUNTIF(D:D,"Active") |
MAX / MIN | Largest / smallest | =MAX(B2:B50) |
PRODUCT | Multiply | =PRODUCT(B2,C2) |
ROUND | Round number | =ROUND(B2*0.1, 2) |
CONCATENATE | Join text | =CONCATENATE(A2," ",B2) |
Function Categories
- Math & Trig — SUM, PRODUCT, ROUND, ABS, CEILING, FLOOR, MOD, POWER, SQRT, SUMIF, SUMIFS, SUMPRODUCT
- Statistical — AVERAGE, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MEDIAN, STDEV, VAR, MAX, MIN, LARGE, SMALL
- Logical — IF, AND, OR, NOT, IFERROR, IFNA, SWITCH, IFS, TRUE, FALSE
- Lookup & Reference — VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, OFFSET, INDIRECT, ROW, COLUMN
- Text — CONCATENATE, LEFT, RIGHT, MID, LEN, UPPER, LOWER, TRIM, SUBSTITUTE, TEXT, FIND, SEARCH
- Date & Time — TODAY, NOW, DATE, YEAR, MONTH, DAY, HOUR, MINUTE, DATEDIF, EDATE, EOMONTH
- Financial — PMT, FV, PV, NPV, IRR, RATE
Known Limitations
- VBA Macros — Not supported. Unsheet only processes formula cells.
- GETPIVOTDATA — Not available (no pivot table engine).
- Dynamic arrays — SORT, FILTER, UNIQUE are not yet supported by HyperFormula.
- External references — References to other workbooks are not resolved.
- Custom functions — User-defined functions from Excel add-ins are not available.
Found this useful?
Share it with your team or network.
Frequently Asked Questions
Does Unsheet support VLOOKUP?
Yes. VLOOKUP, HLOOKUP, INDEX, MATCH, and other lookup functions are fully supported.
What Excel functions are NOT supported?
Some Excel-specific functions like GETPIVOTDATA, certain array formulas, and VBA macros are not supported. All standard mathematical, statistical, logical, text, date, and lookup functions work.
Related Guides
✨Features· 6 min
Live Formula Recalculation — How Unsheet Keeps Your Data Alive
Unsheet uses HyperFormula to evaluate 400+ Excel functions in real-time. Edit any value and watch totals, charts, and metrics update instantly.
🚀Getting Started· 5 min
Upload Your First Spreadsheet to Unsheet — Complete Walkthrough
Step-by-step guide to uploading an Excel or CSV file and watching Unsheet's AI transform it into a live web application with charts and formulas.
Ready to kill your spreadsheets?
Upload your first file and see the magic in under 30 seconds.
Get Started Free →