This article details the Excel formulas that are supported within Solver Cloud
Solver’s web interface supports many but unfortunately not all Excel formulas. Due to the millions of possible Excel formula combinations, there may be a formula 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 formula complexity, there may be instances where a certain formula does to 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 | XNPV |
| 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 |