Documentation/Calc Functions/List of Functions/en

Mathematical functions
 ABS ACOS ACOSH ACOT ACOTH AGGREGATE ASIN ASINH ATAN ATAN2 ATANH BITAND BITLSHIFT BITOR BITRSHIFT BITXOR CEILING CEILING.MATH CEILING.PRECISE CEILING.XCL COLOR COMBIN COMBINA CONVERT_OOO COS COSH COT COTH CSC CSCH DEGREES EUROCONVERT EVEN EXP FACT FLOOR FLOOR.MATH FLOOR.PRECISE FLOOR.XCL GCD GCD_EXCEL2003 INT ISO.CEILING LCM LCM_EXCEL2003 LN LOG LOG10 MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RAND.NV RANDBETWEEN RANDBETWEEN.NV RAWSUBTRACT ROUND ROUNDDOWN ROUNDSIG ROUNDUP SEC SECH SERIESSUM SIGN SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMIFS SUMSQ TAN TANH TRUNC ^top

Financial analysis functions
 ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMIPMT_ADD CUMPRINC CUMPRINC_ADD DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT EFFECT_ADD FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NOMINAL_ADD NPER NPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD OPT_BARRIER OPT_PROB_HIT OPT_PROB_INMONEY OPT_TOUCH PDURATION PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED RRI SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT ^top

Statistical analysis functions
 AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS B BETA.DIST BETA.INV BETADIST BETAINV BINOM.DIST BINOM.INV BINOMDIST CHIDIST CHIINV CHISQ.DIST CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST CHISQDIST CHISQINV CHITEST CONFIDENCE CONFIDENCE.NORM CONFIDENCE.T CORREL COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVAR COVARIANCE.P COVARIANCE.S CRITBINOM DEVSQ ERF.PRECISE ERFC.PRECISE EXPON.DIST EXPONDIST F.DIST F.DIST.RT F.INV F.INV.RT F.TEST FDIST FINV FISHER FISHERINV FORECAST FORECAST.ETS.ADD FORECAST.ETS.MULT FORECAST.ETS.PI.ADD FORECAST.ETS.PI.MULT FORECAST.ETS.SEASONALITY FORECAST.ETS.STAT.ADD FORECAST.ETS.STAT.MULT FORECAST.LINEAR FTEST GAMMA GAMMA.DIST GAMMA.INV GAMMADIST GAMMAINV GAMMALN GAMMALN.PRECISE GAUSS GEOMEAN HARMEAN HYPGEOM.DIST HYPGEOMDIST INTERCEPT KURT LARGE LOGINV LOGNORM.DIST LOGNORM.INV LOGNORMDIST MAX MAXA MAXIFS MEDIAN MIN MINA MINIFS MODE MODE.MULT MODE.SNGL NEGBINOM.DIST NEGBINOMDIST NORM.DIST NORM.INV NORM.S.DIST NORM.S.INV NORMDIST NORMINV NORMSDIST NORMSINV PEARSON PERCENTILE PERCENTILE.EXC PERCENTILE.INC PERCENTRANK PERCENTRANK.EXC PERCENTRANK.INC PERMUT PERMUTATIONA PHI POISSON POISSON.DIST PROB QUARTILE QUARTILE.EXC QUARTILE.INC RANK RANK.AVG RANK.EQ RSQ SKEW SKEWP SLOPE SMALL STANDARDIZE STDEV STDEV.P STDEV.S STDEVA STDEVP STDEVPA STEYX T.DIST T.DIST.2T T.DIST.RT T.INV T.INV.2T T.TEST TDIST TINV TRIMMEAN TTEST VAR VAR.P VAR.S VARA VARP VARPA WEIBULL WEIBULL.DIST Z.TEST ZTEST ^top

Date and time functions
 DATE DATEDIF DATEVALUE DAY DAYS DAYS360 DAYSINMONTH DAYSINYEAR EASTERSUNDAY EDATE EOMONTH HOUR ISLEAPYEAR ISOWEEKNUM MINUTE MONTH MONTHS NETWORKDAYS NETWORKDAYS.INTL NETWORKDAYS_EXCEL2003 NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WEEKNUM_EXCEL2003 WEEKS WEEKSINYEAR WORKDAY WORKDAY.INTL YEAR YEARFRAC YEARS ^top

Logical functions
 AND FALSE IF IFERROR IFNA IFS NOT OR SWITCH TRUE XOR ^top

Information functions
 CELL CURRENT FORMULA INFO ISBLANK ISERR ISERROR ISEVEN ISEVEN_ADD ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISODD_ADD ISREF ISTEXT N NA TYPE ^top

Database functions
 DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP ^top

Array functions
 FOURIER FREQUENCY GROWTH LINEST LOGEST MDETERM MINVERSE MMULT MUNIT SUMPRODUCT SUMX2MY2 SUMX2PY2 SUMXMY2 TRANSPOSE TREND ^top

Spreadsheet functions
 ADDRESS AREAS CHOOSE COLUMN COLUMNS DDE ERROR.TYPE ERRORTYPE GETPIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS SHEET SHEETS STYLE VLOOKUP ^top

Text functions
 ARABIC ASC BAHTTEXT BASE CHAR CLEAN CODE CONCAT CONCATENATE DECIMAL DOLLAR ENCODEURL EXACT FILTERXML FIND FINDB FIXED JIS LEFT LEFTB LEN LENB LOWER MID MIDB NUMBERVALUE PROPER REGEX REPLACE REPLACEB REPT RIGHT RIGHTB ROMAN ROT13 SEARCH SEARCHB SUBSTITUTE T TEXT TEXTJOIN TRIM UNICHAR UNICODE UPPER VALUE WEBSERVICE ^top

Add-in functions
 BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERFC FACTDOUBLE GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMCOSH IMCOT IMCSC IMCSCH IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSEC IMSECH IMSIN IMSINH IMSQRT IMSUB IMSUM IMTAN OCT2BIN OCT2DEC OCT2HEX ^top

Functions not contained in the Wizard
 MULTIPLE.OPERATIONS ^top