Matrix Functions MDETERM MINVERSE MMULT MUNIT TRANSPOSE Bit operation functions BITAND BITLSHIFT BITOR BITRSHIFT BITXOR Byte-position text functions FINDB LEFTB LENB MIDB REPLACEB RIGHTB SEARCHB Complex Number Functions COMPLEX IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMCOSH IMCOT IMCSC IMCSCH IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSINH IMSEC IMSECH IMSQRT IMSUB IMSUM IMTAN Database Functions DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP Date and Time Functions DATE DATEDIF DATEVALUE DAY DAYS DAYS360 EDATE EOMONTH HOUR ISOWEEKNUM MINUTE MONTH NETWORKDAYS NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY YEAR YEARFRAC External Access Functions DDE HYPERLINK Financial Functions ACCRINT ACCRINTM AMORLINC COUPDAYBS COUPDAYS COUPDAYNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PDURATION PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED RRI SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT Information Functions AREAS CELL COLUMN COLUMNS COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS -- Don't generate etc-fn COUNTIFS. ERROR.TYPE FORMULA INFO ISBLANK ISERR ISERROR ISEVEN ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA NUMBERVALUE ROW ROWS SHEET SHEETS TYPE VALUE Lookup Functions ADDRESS CHOOSE HLOOKUP INDEX INDIRECT LOOKUP MATCH MULTIPLE.OPERATIONS OFFSET VLOOKUP Logical Functions AND FALSE IF -- Don't generate manual-fn IF. IFERROR IFNA NOT OR TRUE XOR Mathematical Functions ABS ACOS ACOSH ACOT ACOTH ASIN ASINH ATAN ATAN2 ATANH BESSELI BESSELJ BESSELK BESSELY COMBIN COMBINA CONVERT COS COSH COT COTH CSC CSCH DEGREES DELTA ERF ERFC EUROCONVERT EVEN EXP FACT FACTDOUBLE GAMMA GAMMALN GCD GESTEP LCM LN LOG LOG10 MOD MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN SEC SERIESSUM SIGN SIN SINH SECH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMIFS -- Don't generate etc-fn SUMIFS. SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH Rounding Functions CEILING INT FLOOR MROUND ROUND ROUNDDOWN ROUNDUP TRUNC Statistical Functions AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS -- Don't generate etc-fn AVERAGEIFS. BETADIST BETAINV BINOM.DIST.RANGE BINOMDIST LEGACY.CHIDIST CHISQDIST LEGACY.CHIINV CHISQINV LEGACY.CHITEST CONFIDENCE CORREL COVAR CRITBINOM DEVSQ EXPONDIST FDIST LEGACY.FDIST FINV LEGACY.FINV FISHER FISHERINV FORECAST FREQUENCY FTEST GAMMADIST GAMMAINV GAUSS GEOMEAN GROWTH HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMDIST NORMINV LEGACY.NORMSDIST LEGACY.NORMSINV PEARSON PERCENTILE PERCENTRANK PERMUT PERMUTATIONA PHI POISSON PROB QUARTILE RANK RSQ SKEW SKEWP SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX LEGACY.TDIST TINV TREND TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST Number Representation Conversion Functions ARABIC BASE BIN2DEC BIN2HEX BIN2OCT DEC2BIN DEC2HEX DEC2OCT DECIMAL HEX2BIN HEX2DEC HEX2OCT OCT2BIN OCT2DEC OCT2HEX ROMAN Text Functions ASC CHAR CLEAN CODE CONCATENATE DOLLAR EXACT FIND FIXED JIS LEFT LEN LOWER MID PROPER REPLACE REPT RIGHT SEARCH SUBSTITUTE T TEXT TRIM UNICHAR UNICODE UPPER