This article details the Excel functions that are supported within Solver Cloud
Solver’s web interface supports many but unfortunately not all Excel functions. Due to the millions of possible Excel function combinations, there may be a function that is not supported. Below is a list of all Excel functions supported in the latest version of the Solver Cloud and Private host product.
In general, most report formulas will work, but depending on their use case and function complexity, there may be instances where a certain function does work and returns either a #ref or #name.
| ABS | COMBINA | DVARP | IMCONJUGATE | MATCH | PMT | SQRT | WORKDAY.INTL |
| ACCRINT | COMPLEX | EDATE | IMCOS | MAX | PERCENTILE | SQRTPI | XIRR |
| ACCRINTM | CONCATENATE | EFFECT | IMCOSH | MAXA | PERCENTILE.EXC | STANDARDIZE | XLOOKUP |
| ACOS | CONFIDENCE | ENCODEURL | IMCOT | MDETERM | PERCENTILE.INC | STDEV | XOR |
| ACOSH | CONFIDENCE.NORM | EOMONTH | IMCSC | MDURATION | PERCENTRANK | STDEV.P | YEAR |
| ACOT | CONFIDENCE.T | ERF | IMCSCH | MEDIAN | PERCENTRANK.EXC | STDEV.S | YEARFRAC |
| ACOTH | CONVERT | ERF.PRECISE | IMDIV | MID | PERCENTRANK.INC | STDEVA | YIELD |
| ADDRESS | CORREL | ERFC | IMEXP | MIDB | PERMUT | STDEVP | YIELDDISC |
| AMORDEGRC | COS | ERFC.PRECISE | IMLN | MIN | PERMUTATIONA | STDEVPA | YIELDMAT |
| AMORLINC | COSH | ERROR.TYPE | IMLOG10 | MINA | PHI | STEYX | Z.TEST |
| AND | COT | EVEN | IMLOG2 | MINUTE | PI | SUBSTITUTE | ZTEST |
| ARABIC | COTH | EXACT | IMPOWER | MINVERSE | PMT | SUBTOTAL | FALSE |
| AREAS | COUNT | EXP | IMPRODUCT | MIRR | POISSON | SUM | TRUE |
| ASIN | COUNTA | EXPON.DIST | IMREAL | MMULT | POISSON.DIST | SUMIF | |
| ASINH | COUNTBLANK | EXPONDIST | IMSEC | MOD | POWER | SUMIFS | |
| ATAN | COUNTIF | F.DIST | IMSECH | MODE | PPMT | SUMPRODUCT | |
| ATAN2 | COUNTIFS | F.DIST.RT | IMSIN | MODE.MULT | PRICE | SUMSQ | |
| ATANH | COUPDAYBS | F.INV | IMSINH | MODE.SNGL | PRICEDISC | SUMX2MY2 | |
| AVEDEV | COUPDAYS | F.INV.RT | IMSQRT | MONTH | PRICEMAT | SUMX2PY2 | |
| AVERAGE | COUPDAYSNC | F.TEST | IMSUB | MROUND | PROB | SUMXMY2 | |
| AVERAGEA | COUPNCD | FACT | IMSUM | MULTINOMIAL | PRODUCT | SYD | |
| AVERAGEIF | COUPNUM | FACTDOUBLE | IMTAN | N | PROPER | T | |
| AVERAGEIFS | COUPPCD | FDIST | INDEX | NA | PV | T.DIST | |
| BASE | COVAR | FIND | INDIRECT | NEGBINOM.DIST | QUARTILE | T.DIST.2T | |
| BESSELI | COVARIANCE.P | FINDB | INT | NEGBINOMDIST | QUARTILE.EXC | T.DIST.RT | |
| BESSELJ | COVARIANCE.S | FINV | INTERCEPT | NETWORKDAYS | QUARTILE.INC | T.INV | |
| BESSELK | CRITBINOM | FISHER | INTRATE | NETWORKDAYS.INTL | QUOTIENT | T.INV.2T | |
| BESSELY | CSC | FISHERINV | IPMT | NOMINAL | RADIANS | T.TEST | |
| BETA.DIST | CSCH | FIXED | IRR | NORM.DIST | RAND | TAN | |
| BETA.INV | CUMIPMT | FLOOR | ISBLANK | NORM.INV | RANDBETWEEN | TANH | |
| BETADIST | CUMPRINC | FLOOR.MATH | ISERR | NORM.S.DIST | RANK | TBILLEQ | |
| BETAINV | DATE | FLOOR.PRECISE | ISERROR | NORM.S.INV | RANK.AVG | TBILLPRICE | |
| BIN2DEC | DATEDIF | FORECAST | ISEVEN | NORMDIST | RANK.EQ | TBILLYIELD | |
| BIN2HEX | DATEVALUE | FREQUENCY | ISFORMULA | NORMINV | RATE | TDIST | |
| BIN2OCT | DAVERAGE | FTEST | ISLOGICAL | NORMSDIST | RECEIVED | TEXT | |
| BINOM.DIST | DAY | FV | ISNA | NORMSINV | REPLACE | TIME | |
| BINOM.DIST.RANGE | DAYS | FVSCHEDULE | ISNONTEXT | NOT | REPLACEB | TIMEVALUE | |
| BINOM.INV | DAYS360 | GAMMA | ISNUMBER | NOW | REPT | TINV | |
| BINOMDIST | DB | GAMMA.DIST | ISO.CEILING | NPER | RIGHT | TODAY | |
| BITAND | DCOUNT | GAMMA.INV | ISODD | NPV | RIGHTB | TRANSPOSE | |
| BITLSHIFT | DCOUNTA | GAMMADIST | ISOWEEKNUM | OCT2BIN | ROMAN | TREND | |
| BITOR | DDB | GAMMAINV | ISPMT | OCT2DEC | ROUND | TRIM | |
| BITRSHIFT | DEC2BIN | GAMMALN | ISREF | OCT2HEX | ROUNDDOWN | TRIMMEAN | |
| BITXOR | DEC2HEX | GAMMALN.PRECISE | ISTEXT | ODD | ROUNDUP | TRUNC | |
| CEILING | DEC2OCT | GAUSS | KURT | ODDFPRICE | ROW | TTEST | |
| CEILING.MATH | DECIMAL | GCD | LARGE | ODDFYIELD | ROWS | TYPE | |
| CEILING.PRECISE | DEGREES | GEOMEAN | LCM | ODDLPRICE | RRI | UNICHAR | |
| CHAR | DELTA | GESTEP | LEFT | ODDLYIELD | RSQ | UNICODE | |
| CHIDIST | DEVSQ | GROWTH | LEFTB | OFFSET | SEARCH | UPPER | |
| CHIINV | DGET | HARMEAN | LEN | OR | SEARCHB | VALUE | |
| CHISQ.DIST | DISC | HEX2BIN | LENB | PDURATION | SEC | VAR | |
| CHISQ.DIST.RT | DMAX | HEX2DEC | LINEST | PEARSON | SECH | VAR.P | |
| CHISQ.INV | DMIN | HEX2OCT | LN | PERCENTILE | SECOND | VAR.S | |
| CHISQ.INV.RT | DOLLAR | HLOOKUP | LOG | PERCENTILE.EXC | SERIESSUM | VARA | |
| CHISQ.TEST | DOLLARDE | HOUR | LOG10 | PERCENTILE.INC | SIGN | VARP | |
| CHITEST | DOLLARFR | HYPERLINK | LOGEST | PERCENTRANK | SIN | VARPA | |
| CHOOSE | DPRODUCT | IF | LOGINV | PERCENTRANK.EXC | SINH | VDB | |
| CLEAN | DSTDEV | IFERROR | LOGNORM.DIST | PERCENTRANK.INC | SKEW | VLOOKUP | |
| CODE | DSTDEVP | IFNA | LOGNORM.INV | PERMUT | SKEW.P | WEEKDAY | |
| COLUMN | DSUM | IMABS | LOGNORMDIST | PERMUTATIONA | SLN | WEEKNUM | |
| COLUMNS | DURATION | IMAGINARY | LOOKUP | PHI | SLOPE | WEIBULL | |
| COMBIN | DVAR | IMARGUMENT | LOWER | PI | SMALL | WORKDAY |