Chapter 2 Built-In Functions

Built-In Functions

The following built-in functions can be used in formulas.

ABS	ACOS	ACOSH	ADD
AND	ASIN	ASINH	ATAN
ATAN2	ATANH	AVEDEV	AVERAGE
BETADIST	BETAINV	BINOMDIST	CEILING
CHAR	CHIDIST	CHIINV	CLEAN
CODE	COMBIN	CONCATENATE	CONFIDENCE
COS	COSH	COUNT	COUNTA
COUNTIF	CRITBINOM	DATE	DAY
DAYS360	DB	DDB	DEGREES
DEVSQ	EVEN	EXACT	EXP
EXPONDIST	FACT	FALSE	FDIST
FIND	FINV	FISHER	FISHERINV
FLOOR	FV	GAMMADIST	GAMMAINV
GAMMALN	HOUR	HYPGEOMDIST	IF
INT	INVERSE	IPMT	IRR
ISBLANK	ISEVEN	ISNONTEXT	ISNUMBER
ISODD	ISPMT	ISREF	ISTEXT
LEFT	LEN	LN	LOG
LOG10	LOGINV	LOGNORMDIST	LOWER
MAX	MEDIAN	MID	MIN
MINUTE	MIRR	MOD	MODE
MONTH	NEG	NEGBINOMDIST	NORMDIST
NORMINV	NORMSDIST	NORMSINV	NOT
NOW	NPER	NPV	ODD
OR	PERMUT	PI	PMT
PMTXL	POISSON	POWER	PPMT
PRODUCT	PROPER	PV	RADIANS
RAND	RANK	REPLACE	REPT
RIGHT	ROUND	ROUNDDOWN	ROUNDUP
SECOND	SIGN	SIN	SINH
SKEW	SLN	SQRT	SQUARE
STANDARDIZE	STDEV	STDEVP	SUBSTITUTE
SUBTOTAL	SUM	SUMIF	SUMPRODUCT
SUMSQ	SYD	TAN	TANH
TDIST	TIME	TINV	TODAY
TRIM	TRUE	TRUNC	UPPER
URL	VAR	VARP	VDB
WEEKDAY	WEIBULL	XROOT	YEAR

The description of each function provides an example. Examples that provide results give decimal values for 10 decimal places.

For most functions, the arguments can be numeric values, cell references, or mathematical expressions that contain cell references, or other values as described in the summary of that function.

For an overall explanation of formulas and how functions are used in formulas, refer to the Formula Overview.