Module functions

Expand description

Built-in Excel function dispatch.

Provides lookup_function to resolve a function name to its implementation, and helper utilities used by individual function implementations.

Modules§

date_time: Date/time formula functions: DATE, TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATEDIF, EDATE, EOMONTH, DATEVALUE, WEEKDAY, WEEKNUM, NETWORKDAYS, WORKDAY.
engineering: Engineering formula functions: base conversion (BIN2DEC, BIN2HEX, etc.), complex numbers (COMPLEX, IMREAL, IMAGINARY, etc.), DELTA, GESTEP, ERF, ERFC, CONVERT, and Bessel functions.
financial: Financial formula functions: FV, PV, NPV, IRR, PMT, IPMT, PPMT, RATE, NPER, DB, DDB, SLN, SYD, EFFECT, NOMINAL, DOLLARDE, DOLLARFR, CUMPRINC, CUMIPMT, XNPV, XIRR.
information: Information formula functions: ISERR, ISNA, ISLOGICAL, ISEVEN, ISODD, TYPE, N, NA, ERROR.TYPE.
logical: Logical formula functions: TRUE, FALSE, IFERROR, IFNA, IFS, SWITCH, XOR.
lookup: Lookup and reference formula functions: VLOOKUP, HLOOKUP, INDEX, MATCH, LOOKUP, ROW, COLUMN, ROWS, COLUMNS, CHOOSE, ADDRESS.
math: Math formula functions: SUMIF, SUMIFS, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, SIGN, RAND, RANDBETWEEN, PI, LOG, LOG10, LN, EXP, PRODUCT, QUOTIENT, FACT.
statistical: Statistical formula functions: AVERAGEIF, AVERAGEIFS, COUNTBLANK, COUNTIF, COUNTIFS, MEDIAN, MODE, LARGE, SMALL, RANK.
text: Text formula functions: CONCAT, FIND, SEARCH, SUBSTITUTE, REPLACE, REPT, EXACT, T, PROPER.

check_arg_count: Verify that args has between min and max entries (inclusive).
collect_criteria_range_values: Expand a single argument expression into a flat list of CellValues.
lookup_function: Resolve a function name (case-insensitive) to its implementation.
matches_criteria: Check whether a cell value matches a criteria string.