Supported Excel Functions

Have more questions? Submit a request

The list of Excel functions supported in a custom rater on the Dais platform are

   

"ABS",
"ACOS",
"ACOSH",
"ADDRESS",
"AND",
"AREAS",
"ASIN",
"ASINH",
"ATAN",
"ATAN2",
"ATANH",
"AVEDEV",
"AVERAGE",
"CEILING",
"CHAR",
"CHOOSE",
"CLEAN",
"CODE",
"COLUMN",
"COLUMNS",
"COMBIN",
"CONCATENATE",
"COS",
"COSH",
"COUNT",
"COUNTA",
"COUNTBLANK",
"COUNTIF",
"DATE",
"DATEVALUE",
"DAY",
"DAYS360",
"DEGREES",
"DEVSQ",
"DGET",
"DMAX",
"DMIN",
"DOLLAR",
"DSUM",
"ERROR.TYPE",
"EVEN",
"EXACT",
"EXP",
"FACT",
"FALSE",
"FIND",
"FIXED",
"FLOOR",
"FREQUENCY",
"FV",
"GEOMEAN",
"HLOOKUP",
"HOUR",
"HYPERLINK",
"IF",
"INDEX",
"INDIRECT",
"INT",
"INTERCEPT",
"IPMT",
"IRR",
"ISBLANK",
"ISERR",
"ISERROR",
"ISLOGICAL",
"ISNA",
"ISNONTEXT",
"ISNUMBER",
"ISREF",
"ISTEXT",
"LARGE",
"LEFT",
"LEN",
"LN",
"LOG",
"LOG10",
"LOOKUP",
"LOWER",
"MATCH",
"MAX",
"MAXA",
"MDETERM",
"MEDIAN",
"MID",
"MIN",
"MINA",
"MINUTE",
"MINVERSE",
"MIRR",
"MMULT",
"MOD",
"MODE",
"MONTH",
"NA",
"NOT",
"NOW",
"NPER",
"NPV",
"ODD",
"OFFSET",
"OR",
"PERCENTILE",
"PI",
"PMT",
"POISSON",
"POWER",
"PPMT",
"PRODUCT",
"PROPER",
"PV",
"RADIANS",
"RAND",
"RANK",
"RATE",
"REPLACE",
"REPT",
"RIGHT",
"ROMAN",
"ROUND",
"ROUNDDOWN",
"ROUNDUP",
"ROW",
"ROWS",
"SEARCH",
"SECOND",
"SIGN",
"SIN",
"SINH",
"SLOPE",
"SMALL",
"SQRT",
"STDEV",
"SUBSTITUTE",
"SUBTOTAL",
"SUM",
"SUMIF",
"SUMPRODUCT",
"SUMSQ",
"SUMX2MY2",
"SUMX2PY2",
"SUMXMY2",
"T",
"TAN",
"TANH",
"TEXT",
"TIME",
"TODAY",
"TRANSPOSE",
"TREND",
"TRIM",
"TRUE",
"TRUNC",
"UPPER",
"VALUE",
"VAR",
"VARP",
"VLOOKUP",
"WEEKDAY",
"YEAR"

Articles in this section

Was this article helpful?
0 out of 0 found this helpful