Formulas and functions
Write formulas the way you do in Excel, and get the same results.
- Close to 500 Excel worksheet functions by name, from SUM and VLOOKUP to XLOOKUP, FILTER, UNIQUE, SORT, VSTACK, GROUPBY and PIVOTBY
- Dynamic arrays that spill, LET and LAMBDA, named LAMBDAs, MAP, REDUCE and BYROW
- Absolute, relative and mixed references, other-sheet and 3-D references, table references like Table1[Sales]
- Defined names at workbook or sheet scope, with a Name Manager and Create from Selection
- Trace precedents and dependents, evaluate a formula step by step, show formulas instead of values
- Goal Seek, scenarios and data tables for what-if questions