-
Notifications
You must be signed in to change notification settings - Fork 610
excel formula functions
OfficeCLI's built-in evaluator computes 350+ Excel functions automatically on write — set a formula=, get the cell, and the value is already cached (no round-trip through Office to recalc). Legacy aliases (e.g. NORMDIST for NORM.DIST) are also accepted on input and are listed alongside their modern names below; modern dynamic-array and 2010+ functions are auto-prefixed with _xlfn. on write so Excel resolves them.
See Excel cell reference for reference styles and evaluation semantics.
ABS, AGGREGATE, ARABIC, AVERAGE, BASE, CEILING, CEILING.MATH, COMBIN, COUNT, COUNTA, COUNTBLANK, DECIMAL, EVEN, EXP, FACT, FLOOR, FLOOR.MATH, GCD, INT, LCM, LN, LOG, LOG10, MAX, MIN, MOD, MROUND, ODD, PERMUT, POWER, PRODUCT, QUOTIENT, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SQRT, SUBTOTAL, SUM, SUMPRODUCT, TRUNC
ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, COS, COSH, DEGREES, PI, RADIANS, SIN, SINH, TAN, TANH
GEOMEAN, HARMEAN, LARGE, MEDIAN, MODE, MODE.SNGL, PERCENTILE, PERCENTILE.INC, PERCENTRANK, PERCENTRANK.INC, RANK, RANK.EQ, SMALL, STDEV, STDEV.P, STDEV.S, STDEVP, VAR, VAR.P, VAR.S, VARP
AVEDEV, BETA.DIST, BETA.INV, BETADIST, BETAINV, BINOM.DIST, BINOM.INV, BINOMDIST, CHIDIST, CHIINV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CHITEST, CONFIDENCE, CONFIDENCE.NORM, CORREL, COVAR, COVARIANCE.P, COVARIANCE.S, CRITBINOM, DEVSQ, ERF, ERF.PRECISE, ERFC, ERFC.PRECISE, EXPON.DIST, EXPONDIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, FDIST, FINV, FISHER, FISHERINV, FORECAST, FORECAST.LINEAR, FTEST, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMADIST, GAMMAINV, GAMMALN, GAMMALN.PRECISE, GAUSS, GROWTH, HYPGEOM.DIST, HYPGEOMDIST, INTERCEPT, KURT, LINEST, LOGEST, LOGINV, LOGNORM.DIST, LOGNORM.INV, LOGNORMDIST, NEGBINOM.DIST, NEGBINOMDIST, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, NORMDIST, NORMINV, NORMSDIST, NORMSINV, PEARSON, PERCENTILE.EXC, PERMUTATIONA, PHI, POISSON, POISSON.DIST, QUARTILE, QUARTILE.EXC, QUARTILE.INC, RSQ, SKEW, SKEW.P, SLOPE, STANDARDIZE, STEYX, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, T.TEST, TDIST, TINV, TREND, TRIMMEAN, TTEST, WEIBULL, WEIBULL.DIST, Z.TEST, ZTEST
AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF, SUMIFS
AND, CHOOSE, FALSE, IF, IFERROR, IFNA, IFS, ISOMITTED, NOT, OR, REDUCE, SWITCH, TRUE, XOR
CHAR, CLEAN, CODE, CONCAT, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, N, NUMBERVALUE, PROPER, REGEXEXTRACT, REGEXREPLACE, REGEXTEST, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TEXTAFTER, TEXTBEFORE, TEXTJOIN, TRIM, UPPER, VALUE, YEN
ADDRESS, CELL, COLUMN, COLUMNS, HLOOKUP, HYPERLINK, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, SHEET, SHEETS, VLOOKUP, XLOOKUP
BYCOL, BYROW, CHOOSECOLS, CHOOSEROWS, DROP, EXPAND, FILTER, HSTACK, MAKEARRAY, MAP, SCAN, SEQUENCE, SORT, SORTBY, TAKE, TEXTSPLIT, TOCOL, TOROW, TRANSPOSE, UNIQUE, VSTACK, WRAPCOLS, WRAPROWS
DATE, DATEDIF, DATEVALUE, DAY, DAYS, EDATE, EOMONTH, HOUR, ISOWEEKNUM, MINUTE, MONTH, NETWORKDAYS, NETWORKDAYS.INTL, NOW, SECOND, TIMEVALUE, TODAY, WEEKDAY, WORKDAY, WORKDAY.INTL, YEAR, YEARFRAC
ERROR.TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, NA, TYPE
CUMIPMT, CUMPRINC, DB, DDB, DOLLARDE, DOLLARFR, EFFECT, FV, FVSCHEDULE, IPMT, IRR, ISPMT, MIRR, NOMINAL, NPER, NPV, PDURATION, PMT, PPMT, PV, RATE, RRI, SLN, SYD, XIRR, XNPV
ACCRINT, ACCRINTM, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, DISC, DURATION, INTRATE, MDURATION, PRICE, PRICEDISC, PRICEMAT, RECEIVED, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT
DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
COMPLEX, IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN
BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, DELTA, GESTEP
-
Odd-period securities:
ODDFPRICE,ODDFYIELD,ODDLPRICE,ODDLYIELD— the SIA odd first/last coupon-period formulas are not yet implemented. -
INFO— environment-dependent (OS, recalc mode, file count); not evaluated.
A formula that calls an unsupported function is still written to the workbook verbatim; it simply is not pre-evaluated, so Format["evaluated"] is false until Excel opens and recalculates it.