Excel Function Reference by category

Compatibility
BETADIST function	COVAR function	GAMMADIST function
BETAINV function	CRITBINOM function	LOGNORMDIST function
BINOMDIST function	EXPONDIST function	MODE function
CHIDIST function	FDIST function	PERCENTRANK function
CHIINV function	FLOOR function	QUARTILE function
CHITEST function	FORECAST function	RANK function
CONFIDENCE function	FTEST function	STDEV function

Database
DAVERAGE function	DMAX function	DSTDEVP function
DCOUNT function	DMIN function	DSUM function
DCOUNTA function	DPRODUCT function	DVARP function
DGET function	DSTDEV function

Date and time
DATE function	MINUTE function	TODAY function
DATEDIF function	MONTH function	WEEKDAY function
DATEVALUE function	NETWORKDAYS function	WEEKNUM function
DAY function	NETWORKDAYS.INTL function	WORKDAY function
DAYS function	NOW function	YEAR function
EDATE function	SECOND function	YEARFRAC function
EOMONTH function	TIME function
HOUR function	TIMEVALUE function

Engineering
BIN2DEC function	BITOR function	DEC2BIN function
BIN2HEX function	BITRSHIFT function	DEC2HEX function
BIN2OCT function	BITXOR function	DEC2OCT function
BITAND function	COMPLEX function	DELTA function
BITLSHIFT function	CONVERT function

Financial
ACCRINT function	EFFECT function	PV function
ACCRINTM function	FV function	RATE function
AMORDEGRC function	IPMT function	RRI function
AMORLINC function	ISPMT function	SYD function
CUMIPMT function	NOMINAL function	TBILLPRICE function
CUMPRINC function	PDURATION function	TBILLYIELD function
DB function	PMT function	VDB function
DDB function	PPMT function	XNPV function
DOLLARFR function	PRICEMAT function	YIELD function

Information
CELL function	ISLOGICAL function	N function
ERROR.TYPE function	ISNA function	NA function
INFO function	ISNONTEXT function	SHEET function
ISBLANK function	ISNUMBER function	SHEETS function
ISERR function	ISODD function	TYPE function
ISERROR function	ISREF function
ISFORMULA function	ISTEXT function

Logical
AND function	IFNA function	SWITCH function
FALSE function	IFS function	TRUE function
IF function	NOT function	XOR function
IFERROR function	OR function

Lookup and reference
ADDRESS function	HLOOKUP function	ROW function
AREAS function	HYPERLINK function	ROWS function
CHOOSE function	INDEX function	SORT function
COLUMN function	INDIRECT function	SORTBY function
COLUMNS function	LOOKUP function	TRANSPOSE function
FILTER function	MATCH function	UNIQUE function
FORMULATEXT function	OFFSET function	VLOOKUP function

Math and trigonometry
ABS function	FACT function	ROUND function
ACOS function	FACTDOUBLE function	ROUNDDOWN function
ACOSH function	FLOOR.MATH function	ROUNDUP function
ACOT function	FLOOR.PRECISE function	SEC function
ACOTH function	GCD function	SECH function
AGGREGATE function	INT function	SEQUENCE function
ASIN function	LCM function	SERIESSUM function
ASINH function	LN function	SIGN function
ATAN function	LOG function	SIN function
ATAN2 function	LOG10 function	SINH function
ATANH function	MINVERSE function	SQRT function
BASE function	MMULT function	SUM function
CEILING function	MOD function	SUMIF function
COMBIN function	MROUND function	SUMIFS function
COMBINA function	MULTINOMIAL function	SUMPRODUCT function
COS function	MUNIT function	SUMSQ function
COSH function	PI function	SUMX2MY2 function
COT function	POWER function	SUMX2PY2 function
COTH function	PRODUCT function	SUMXMY2 function
CSC function	QUOTIENT function	TAN function
DECIMAL function	RADIANS function	TANH function
DEGREES function	RAND function	TRUNC function
EVEN function	RANDARRAY function	SUBTOTAL function
EXP function	RANDBETWEEN function

Statistical
AVEDEV function	EXPON.DIST function	NORM.INV function
AVERAGE function	F.DIST function	PERCENTRANK.EXC function
AVERAGEA function	F.DIST.RT function	PERCENTRANK.INC function
AVERAGEIF function	F.TEST function	PERMUT function
AVERAGEIFS function	FORECAST.LINEAR function	PERMUTATIONA function
BETA.DIST function	FREQUENCY function	PHI function
BETA.INV function	GAMMA function	PROB function
BINOM.DIST function	GAMMA.DIST function	QUARTILE.EXC function
BINOM.INV function	GEOMEAN function	QUARTILE.INC function
CHISQ.DIST function	GROWTH function	RANK.AVG function
CHISQ.DIST.RT function	INTERCEPT function	RANK.EQ function
CHISQ.INV function	LARGE function	SKEW function
CHISQ.INV.RT function	LINEST function	SLOPE function
CHISQ.TEST function	LOGEST function	SMALL function
CONFIDENCE.NORM function	LOGNORM.DIST function	STANDARDIZE function
CONFIDENCE.T function	MAX function	STDEV.P function
CORREL function	MAXIFS function	STDEV.S function
COUNT function	MEDIAN function	STDEVA function
COUNTA function	MIN function	STDEVPA function
COUNTBLANK function	MINA function	TREND function
COUNTIF function	MINIFS function	TRIMMEAN function
COUNTIFS function	MODE.MULT function	VAR.P function
COVARIANCE.P function	MODE.SNGL function	VAR.S function
COVARIANCE.S function	NORM.DIST function

Text
ASC function	LEFT function	TEXT function
CHAR function	LEN function	TEXTJOIN function
CLEAN function	LOWER function	TRIM function
CODE function	MID function	UNICHAR function
CONCAT function	REPT function	UNICODE function
CONCATENATE function	RIGHT function	UPPER function
EXACT function	SEARCH function	VALUE function
FIND function	SUBSTITUTE function
FIXED function	T function

Web
ENCODEURL function	FILTERXML function	WEBSERVICE function

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form

Excel Function Reference by category

Leave a Reply

How to comment