Formulas and Functions – Full List – Microsoft Excel 365

In any Excel cell, you can fill in different type of information:

1. Text content.
2. Numerical content.
3. Formulas and Functions.

First and second type are static content. This information may fill in only manually. Third type is dynamic and is used for operations with static information (conversions and calculations).

If you want to use any function you need start fill in cell with equals (sign = ) and after that name of function or mathematical operation.

For example, addition “=1+1”

At the further I listed all Excel functions in group:

Excel Text Functions

Functions to Remove Extra Characters

CLEAN

TRIM

Functions to Convert Between Upper & Lower Case

LOWER

PROPER

UPPER

Functions to Convert Excel Data Types

BAHTTEXT

DOLLAR

FIXED

TEXT

VALUE

NUMBERVALUE

Converting Between Characters & Numeric Codes

CHAR

CODE

UNICHAR

UNICODE

Cutting Up & Piecing Together Text Strings

CONCAT

CONCATENATE

LEFT

MID

RIGHT

REPT

TEXTJOIN

Information Functions

LEN

FIND

SEARCH

EXACT

T

Replacing / Substituting Parts of a Text String

REPLACE

SUBSTITUTE

Excel Logical Functions

Boolean Operator Functions

AND

OR

XOR

NOT

Functions Returning Constant Values

TRUE

FALSE

Conditional Functions

IF

IFERROR

IFNA

IFS

SWITCH

Excel Information Functions

Error Information Functions

ISERROR

ISERR

ISNA

ERROR.TYPE

Numerical Information Functions

ISNUMBER

ISEVEN

ISODD

N

Function Returning a Constant Value

NA

Other Data Type Functions

ISBLANK

ISLOGICAL

ISTEXT

ISNONTEXT

ISREF

ISFORMULA

TYPE

General Information Functions

CELL

SHEET

SHEETS

INFO

Excel Date and Time Functions

Creating Dates & Times

DATE

TIME

DATEVALUE

TIMEVALUE

Current Date & Time

NOW

TODAY

Extracting The Components of a Time

HOUR

MINUTE

SECOND

Extracting The Components of a Date

DAY

MONTH

YEAR

WEEKNUM

ISOWEEKNUM

WEEKDAY

Performing Calculations with Dates

EDATE

EOMONTH

WORKDAY

WORKDAY.INTL

DAYS

DAYS360

NETWORKDAYS

NETWORKDAYS.INTL

YEARFRAC

Excel Lookup and Reference Functions

Data Lookup Functions

HLOOKUP

VLOOKUP

LOOKUP

GETPIVOTDATA

CHOOSE

MATCH

Row / Column / Area Information

ROW

COLUMN

ROWS

COLUMNS

AREAS

Functions To Return References to Cell Ranges

ADDRESS

INDEX

INDIRECT

OFFSET

Other

HYPERLINK

TRANSPOSE

RTD

FORMULATEXT

Excel Math and Trig Functions

Basic Numeric Information

ABS

SIGN

GCD

LCM

Basic Mathematical Operations

SUM

PRODUCT

POWER

SQRT

QUOTIENT

MOD

AGGREGATE

SUBTOTAL

Rounding Functions

CEILING

CEILING.PRECISE

ISO.CEILING

CEILING.MATH

EVEN

FLOOR

FLOOR.PRECISE

FLOOR.MATH

INT

MROUND

ODD

ROUND

ROUNDDOWN

ROUNDUP

TRUNC

Matrix Functions

MDETERM

MINVERSE

MMULT

MUNIT

Random Numbers

RAND

RANDBETWEEN

Conditional Sums

SUMIF

SUMIFS

Advanced Mathematical Operations

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

SERIESSUM

Trigonometry Functions

PI

SQRTPI

DEGREES

RADIANS

COS

ACOS

COSH

ACOSH

SEC

SECH

SIN

ASIN

SINH

ASINH

CSC

CSCH

TAN

ATAN

ATAN2

TANH

ATANH

COT

COTH

ACOT

ACOTH

Exponents & Logarithms

EXP

LN

LOG

LOG10

Factorials

FACT

FACTDOUBLE

MULTINOMIAL

Miscellaneous

BASE

DECIMAL

COMBIN

COMBINA

ARABIC

ROMAN

Excel Statistical Functions

Count & Frequency

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

FREQUENCY

Permutations

PERMUT

PERMUTATIONA

Confidence Intervals

CONFIDENCE

CONFIDENCE.NORM

CONFIDENCE.T

Percentiles, Quartiles & Rank

PERCENTILE

PERCENTILE.INC

PERCENTILE.EXC

QUARTILE

QUARTILE.INC

QUARTILE.EXC

RANK

RANK.EQ

RANK.AVG

PERCENTRANK

PERCENTRANK.INC

PERCENTRANK.EXC

Deviation & Variance

AVEDEV

DEVSQ

STDEV

STDEV.S

STDEVA

STDEVP

STDEV.P

STDEVPA

VAR

VAR.S

VARA

VARP

VAR.P

VARPA

COVAR

COVARIANCE.P

COVARIANCE.S

Trend Line Functions

FORECAST

FORECAST.ETS

FORECAST.ETS.CONFINT

FORECAST.ETS.SEASONALITY

FORECAST.ETS.STAT

FORECAST.LINEAR

INTERCEPT

LINEST

SLOPE

TREND

GROWTH

LOGEST

STEYX

Finding the Largest & Smallest Values

MAX

MAXA

MAXIFS

MIN

MINA

MINIFS

LARGE

SMALL

Averages

AVERAGE

AVERAGEA

AVERAGEIF

AVERAGEIFS

MEDIAN

MODE

MODE.SNGL

MODE.MULT

GEOMEAN

HARMEAN

TRIMMEAN

Distribution & Tests of Probability

BETADIST

BETA.DIST

BETAINV

BETA.INV

BINOMDIST

BINOM.DIST

BINOM.DIST.RANGE

NEGBINOMDIST

NEGBINOM.DIST

CRITBINOM

BINOM.INV

CHIDIST

CHISQ.DIST.RT

CHISQ.DIST

CHIINV

CHISQ.INV.RT

CHISQ.INV

CHITEST

CHISQ.TEST

CORREL

EXPONDIST

EXPON.DIST

FDIST

F.DIST.RT

F.DIST

FINV

F.INV.RT

F.INV

FISHER

FISHERINV

FTEST

F.TEST

GAMMADIST

GAMMA.DIST

GAMMAINV

GAMMA.INV

GAMMA

GAMMALN

GAMMALN.PRECISE

GAUSS

HYPGEOMDIST

HYPGEOM.DIST

KURT

LOGNORMDIST

LOGNORM.DIST

LOGINV

LOGNORM.INV

NORMDIST

NORM.DIST

NORMINV

NORM.INV

NORMSDIST

NORM.S.DIST

NORMSINV

NORM.S.INV

PEARSON

RSQ

PHI

POISSON

POISSON.DIST

PROB

SKEW

SKEW.P

STANDARDIZE

TDIST

T.DIST.2T

T.DIST.RT

T.DIST

TINV

T.INV.2T

T.INV

TTEST

T.TEST

WEIBULL

WEIBULL.DIST

ZTEST

Z.TEST

Excel Database Functions

Database Functions

DAVERAGE

DCOUNT

DCOUNTA

DGET

DMAX

DMIN

Database Functions

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

Excel Financial Functions

Single Cash Flow Functions

FVSCHEDULE

PDURATION

RRI

Interest Rate Conversion Functions

EFFECT

NOMINAL

Security Functions

ACCRINT

ACCRINTM

DISC

DURATION

INTRATE

MDURATION

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

PRICE

PRICEDISC

PRICEMAT

RECEIVED

YIELD

YIELDDISC

YIELDMAT

Coupon Date Functions

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

Treasury Bill Functions

TBILLEQ

TBILLPRICE

TBILLYIELD

Functions for a Series of Periodic Constant Cash Flows

CUMIPMT

CUMPRINC

FV

IPMT

ISPMT

NPER

PMT

PPMT

PV

RATE

Functions for a Series of Periodic Variable Cash Flows

IRR

MIRR

NPV

Functions for a Series of Non-Periodic Variable Cash Flows

XIRR

XNPV

Depreciation and Amortization Functions

AMORDEGRC

AMORLINC

DB

DDB

SLN

SYD

VDB

Dollar Conversion Functions

DOLLARDE

DOLLARFR

Excel Engineering Functions

Converting Between Units of Measurement

CONVERT

Bessel Functions

BESSELI

BESSELJ

BESSELK

BESSELY

Converting Between Bases

BIN2DEC

BIN2HEX

BIN2OCT

DEC2BIN

DEC2HEX

DEC2OCT

HEX2BIN

HEX2DEC

HEX2OCT

OCT2BIN

OCT2DEC

OCT2HEX

The Error Function

ERF

ERF.PRECISE

ERFC

ERFC.PRECISE

Bitwise Functions

BITAND

BITOR

BITXOR

BITLSHIFT

BITRSHIFT

Testing Numeric Values

DELTA

GESTEP

Complex Numbers

COMPLEX

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

Excel Cube Functions

Cube Functions

CUBEKPIMEMBER

CUBEMEMBER

CUBEMEMBERPROPERTY

CUBERANKEDMEMBER

CUBESET

CUBESETCOUNT

CUBEVALUE

Excel Web Functions

Web Functions

ENCODEURL

FILTERXML

WEBSERVICE

Excel Operators

Excel Operators

Basic mathematic operators – addition, subtraction, multiplication and division.

Ampersand – used as sign & and help to concatenate text strings.

Lesson 2 Formulas and FunctionsDownload

Lesson information file