Supported Formulas
Calc Macro Pro and Calc Macro Classic support the same functions. Unknown function names return #NAME?.
The functions are the same, but the cell coordinates are not: Pro counts the header row and column, and Classic skips them. See Pro and Classic for the other differences, and Examples for formulas in context.
Functions
Section titled “Functions”The following 392 functions are supported by both macros.
| ABS | ACCRINT | ACOS | ACOSH |
| ACOT | ACOTH | ADD | AGGREGATE |
| AND | ARABIC | ARGS2ARRAY | ASIN |
| ASINH | ATAN | ATAN2 | ATANH |
| AVEDEV | AVERAGE | AVERAGEA | AVERAGEIF |
| AVERAGEIFS | BASE | BESSELI | BESSELJ |
| BESSELK | BESSELY | BETA.DIST | BETA.INV |
| BETADIST | BETAINV | BIN2DEC | BIN2HEX |
| BIN2OCT | BINOM.DIST | BINOM.DIST.RANGE | BINOM.INV |
| BINOMDIST | BITAND | BITLSHIFT | BITOR |
| BITRSHIFT | BITXOR | CEILING | CEILINGMATH |
| CEILINGPRECISE | CHAR | CHISQ.DIST | CHISQ.DIST.RT |
| CHISQ.INV | CHISQ.INV.RT | CHOOSE | CLEAN |
| CODE | COLUMN | COLUMNS | COMBIN |
| COMBINA | COMPLEX | CONCATENATE | CONFIDENCE |
| CONFIDENCE.NORM | CONFIDENCE.T | CONVERT | CORREL |
| COS | COSH | COT | COTH |
| COUNT | COUNTA | COUNTBLANK | COUNTIF |
| COUNTIFS | COUNTIN | COUNTUNIQUE | COVARIANCE.P |
| COVARIANCE.S | CSC | CSCH | CUMIPMT |
| CUMPRINC | DATE | DATEVALUE | DAY |
| DAYS | DAYS360 | DB | DDB |
| DEC2BIN | DEC2HEX | DEC2OCT | DECIMAL |
| DEGREES | DELTA | DEVSQ | DIVIDE |
| DOLLAR | DOLLARDE | DOLLARFR | E |
| EDATE | EFFECT | EOMONTH | EQ |
| ERF | ERFC | EVEN | EXACT |
| EXP | EXPON.DIST | EXPONDIST | F.DIST |
| F.DIST.RT | F.INV | F.INV.RT | FACT |
| FACTDOUBLE | FALSE | FDIST | FDISTRT |
| FIND | FINV | FINVRT | FISHER |
| FISHERINV | FIXED | FLATTEN | FLOOR |
| FORECAST | FREQUENCY | FV | FVSCHEDULE |
| GAMMA | GAMMA.DIST | GAMMA.INV | GAMMADIST |
| GAMMAINV | GAMMALN | GAMMALN.PRECISE | GAUSS |
| GCD | GEOMEAN | GESTEP | GROWTH |
| GTE | HARMEAN | HEX2BIN | HEX2DEC |
| HEX2OCT | HLOOKUP | HOUR | HTML2TEXT |
| HYPGEOM.DIST | HYPGEOMDIST | IF | IFERROR |
| IFNA | 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 | INT | INTERCEPT |
| INTERVAL | IPMT | IRR | ISBINARY |
| ISBLANK | ISEVEN | ISLOGICAL | ISNONTEXT |
| ISNUMBER | ISODD | ISOWEEKNUM | ISPMT |
| ISTEXT | JOIN | KURT | LARGE |
| LCM | LEFT | LEN | LINEST |
| LN | LOG | LOG10 | LOGEST |
| LOGNORM.DIST | LOGNORM.INV | LOGNORMDIST | LOGNORMINV |
| LOWER | LT | LTE | MATCH |
| MAX | MAXA | MEDIAN | MID |
| MIN | MINA | MINUS | MINUTE |
| MIRR | MOD | MODE.MULT | MODE.SNGL |
| MODEMULT | MODESNGL | MONTH | MROUND |
| MULTINOMIAL | MULTIPLY | NA | NE |
| NEGBINOM.DIST | NEGBINOMDIST | NETWORKDAYS | NOMINAL |
| NORM.DIST | NORM.INV | NORM.S.DIST | NORM.S.INV |
| NORMDIST | NORMINV | NORMSDIST | NORMSINV |
| NOT | NOW | NPER | NPV |
| NUMBERS | NUMERAL | OCT2BIN | OCT2DEC |
| OCT2HEX | ODD | OR | PDURATION |
| PEARSON | PERCENTILEEXC | PERCENTILEINC | PERCENTRANKEXC |
| PERCENTRANKINC | PERMUT | PERMUTATIONA | PHI |
| PI | PMT | POISSON.DIST | POISSONDIST |
| POW | POWER | PPMT | PROB |
| PRODUCT | PROPER | PV | QUARTILE.EXC |
| QUARTILE.INC | QUARTILEEXC | QUARTILEINC | QUOTIENT |
| RADIANS | RAND | RANDBETWEEN | RANK.AVG |
| RANK.EQ | RANKAVG | RANKEQ | RATE |
| REFERENCE | REGEXEXTRACT | REGEXMATCH | REGEXREPLACE |
| REPLACE | REPT | RIGHT | ROMAN |
| ROUND | ROUNDDOWN | ROUNDUP | ROW |
| ROWS | RRI | RSQ | SEARCH |
| SEC | SECH | SECOND | SERIESSUM |
| SIGN | SIN | SINH | SKEW |
| SKEW.P | SKEWP | SLN | SLOPE |
| SMALL | SPLIT | SQRT | SQRTPI |
| STANDARDIZE | STDEV.P | STDEV.S | STDEVA |
| STDEVP | STDEVPA | STDEVS | STEYX |
| SUBSTITUTE | SUBTOTAL | SUM | SUMIF |
| SUMIFS | SUMPRODUCT | SUMSQ | SUMX2MY2 |
| SUMX2PY2 | SUMXMY2 | SWITCH | SYD |
| T | T.DIST | T.DIST.2T | T.DIST.RT |
| T.INV | T.INV.2T | TAN | TANH |
| TBILLEQ | TBILLPRICE | TBILLYIELD | TDIST |
| TDIST2T | TDISTRT | TEXT | TIME |
| TIMEVALUE | TINV | TINV2T | TODAY |
| TRANSPOSE | TREND | TRIM | TRIMMEAN |
| TRUE | TRUNC | UNICHAR | UNICODE |
| UNIQUE | UPPER | VALUE | VAR.P |
| VAR.S | VARA | VARP | VARPA |
| VARS | VLOOKUP | WEEKDAY | WEEKNUM |
| WEIBULL.DIST | WEIBULLDIST | WORKDAY | XIRR |
| XNPV | XOR | YEAR | YEARFRAC |