Supported Excel Functions
The following Excel Functions are supported by Apache POI 5.2.3, the third-party Excel SDK that Jama Connect Interchange uses to run functions in memory.
ABS | DCOUNTA | ISRERR | NOW | SQRT |
ACOS | DEGREES | ISERROR | NPERR | STANDARDIZE |
ACOSH | DEVSQ | ISLOGICAL | NPV | STDEV |
ADDRESS | DGET | ISNA | ODD | STDEVA |
AND | DMAX | ISNONTEXT | OFFSET | STDEVP |
AREAS | DMIN | ISNUMBER | OR | STDEVPA |
ASIN | DOLLAR | ISREF | PEARSON | SUBSTITUTE |
ASINH | DPRODUCT | ISTEXT | PERCENTILE | SUBTOTAL |
ATAN | DSTDEV | LARGE | PERCENTRANK | SUM |
ATAN2 | DSTDEVP | LEFT | PI | SUMIF |
ATANH | DSUM | LEN | PMT | SUMPRODUCT |
AVEDEV | DVAR | LN | POISSON | SUMSQ |
AVERAGE | DVARP | LOG | POWER | SUMX2MY2 |
AVERAGEA | ERROR.TYPE | LOG10 | PPMT | SUMX2PY2 |
CEILING | EVEN | LOOKUP | PRODUCT | SUMXMY2 |
CHAR | EXACT | LOWER | PROPER | T |
CHOOSE | EXP | MATCH | PV | TAN |
CLEAN | FACT | MAX | RADIANS | TANH |
CODE | FALSE | MAXA | RAND | TDIST |
COLUMN | FIND | MDETEREM | RANK | TEXT |
COLUMNS | FIXED | MEDIAN | RATE | TIME |
COMBIN | FLOOR | MID | REPLACE | TIMEVALUE |
CONCATENATE | FORECAST | MIN | REPT | TODAY |
CORREL | FREQUENCY | MINA | RIGHT | TRANSPOSE |
COS | FV | MINUTE | ROMAN | TREND |
COSH | GEOMEAN | MINVERSE | ROUND | TRIM |
COUNT | HLOOKUP | MIRR | ROUNDDOWN | TRUE |
COUNTA | HOUR | MMULT | ROUNDUP | TRUNC |
COUNTBLANK | HYPERLINK | MOD | ROW | UPPER |
COUNIF | IF | MODE | ROWS | VALUE |
COVAR | INDEX | MONTH | SEARCH | VAR |
DATE | INDIRECT | NA | SECOND | VARA |
DATEVALUE | INT | NORMDIST | SIGN | VARP |
DAVERAGE | INTERCEPT | NORMINV | SIN | VARPA |
DAY | IPMT | NORMSDIST | SINH | VLOOKUP |
DAYS360 | IRR | NORMSINV | SLOPE | WEEKDAY |
DCOUNT | ISBLANK | NOT | SMALL | YEAR |