# How do you use functions in Excel?

Excel glossaryWhat is an Excel Function?A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations. Once you are familiar with the

### Excel glossary

## What is an Excel Function?

**A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.**

## Most Frequently Used Functions in Excel

The most frequently used functions in Excel are:

- AutoSum;
- IF function;
- LOOKUP function;
- VLOOKUP function;
- HLOOKUP function;
- MATCH function;
- CHOOSE function;
- DATE function;
- DAYS function;
- FIND & FINDB functions;
- INDEX function;

## List of all Excel Functions

But there are hundreds of other presetformulasoffered by Excel:

ABS

ACCRINT

ACCRINTM

ACOS

ACOSH

ACOT

ACOTH

ADDRESS

AGGREGATE

AMORDEGRC

AMORLINC

AND

ARABIC

AREAS

ASC

ASIN

ASINH

ATAN

ATAN2

ATANH

AVEDEV

AVERAGE

AVERAGEA

AVERAGEIF

AVERAGEIFS

BAHTTEXT

BASE

BESSELI

BESSELJ

BESSELK

BESSELY

BETA.DIST

BETA.INV

BETADIST

BETAINV

BIN2DEC

BIN2HEX

BIN2OCT

BINOM.DIST

BINOM.DIST.RANGE

BINOM.INV

BINOMDIST

BITAND

BITLSHIFT

BITOR

BITRSHIFT

BITXOR

CALL

CEILING

CEILING.MATH

CEILING.PRECISE

CELL

CHAR

CHIDIST

CHIINV

CHISQ.DIST

CHISQ.DIST.RT

CHISQ.INV

CHISQ.INV.RT

CHISQ.TEST

CHITEST

CHOOSE

CLEAN

CODE

COLUMN

COLUMNS

COMBIN

COMBINA

COMPLEX

CONCATENATE

CONFIDENCE

CONFIDENCE.NORM

CONFIDENCE.T

CONVERT

CORREL

COS

COSH

COT

COTH

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

COVAR

COVARIANCE.P

COVARIANCE.S

CRITBINOM

CSC

CSCH

CUBEKPIMEMBER

CUBEMEMBER

CUBEMEMBERPROPERTY

CUBERANKEDMEMBER

CUBESET

CUBESETCOUNT

CUBEVALUE

CUMIPMT

CUMPRINC

DATE

DATEVALUE

DAVERAGE

DAY

DAYS

DAYS360

DB

DBCS

DCOUNT

DCOUNTA

DDB

DEC2BIN

DEC2HEX

DEC2OCT

DECIMAL

DEGREES

DELTA

DEVSQ

DGET

DISC

DMAX

DMIN

DOLLAR

DOLLARDE

DOLLARFR

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DURATION

DVAR

DVARP

EDATE

EFFECT

ENCODEURL

EOMONTH

ERF

ERF.PRECISE

ERFC

ERFC.PRECISE

ERROR.TYPE

EUROCONVERT

EVEN

EXACT

EXP

EXPON.DIST

EXPONDIST

F.DIST

F.DIST.RT

F.INV

F.INV.RT

F.TEST

FACT

FACTDOUBLE

FALSE

FDIST

FILTERXML

FIND, FINDB

FINV

FISHER

FISHERINV

FIXED

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FORECAST

FORMULATEXT

FREQUENCY

FTEST

FV

FVSCHEDULE

GAMMA

GAMMA.DIST

GAMMA.INV

GAMMADIST

GAMMAINV

GAMMALN

GAMMALN.PRECISE

GAUSS

GCD

GEOMEAN

GESTEP

GETPIVOTDATA

GROWTH

HARMEAN

HEX2BIN

HEX2DEC

HEX2OCT

HLOOKUP

HOUR

HYPERLINK

HYPGEOM.DIST

HYPGEOMDIST

IF

IFERROR

IFNA

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

INDEX

INDIRECT

INFO

INT

INTERCEPT

INTRATE

IPMT

IRR

ISBLANK

ISERR

ISERROR

ISEVEN

ISFORMULA

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISO.CEILING

ISODD

ISOWEEKNUM

ISPMT

ISREF

ISTEXT

KURT

LARGE

LCM

LEFT, LEFTB

LEN, LENB

LINEST

LN

LOG

LOG10

LOGEST

LOGINV

LOGNORM.DIST

LOGNORM.INV

LOGNORMDIST

LOOKUP

LOWER

MATCH

MAX

MAXA

MDETERM

MDURATION

MEDIAN

MID, MIDB

MIN

MINA

MINUTE

MINVERSE

MIRR

MMULT

MOD

MODE

MODE.MULT

MODE.SNGL

MONTH

MROUND

MULTINOMIAL

MUNIT

N

NA

NEGBINOM.DIST

NEGBINOMDIST

NETWORKDAYS

NETWORKDAYS.INTL

NOMINAL

NORM.DIST

NORM.INV

NORM.S.DIST

NORM.S.INV

NORMDIST

NORMINV

NORMSDIST

NORMSINV

NOT

NOW

NPER

NPV

NUMBERVALUE

OCT2BIN

OCT2DEC

OCT2HEX

ODD

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

OFFSET

OR

PDURATION

PEARSON

PERCENTILE

PERCENTILE.EXC

PERCENTILE.INC

PERCENTRANK

PERCENTRANK.EXC

PERCENTRANK.INC

PERMUT

PERMUTATIONA

PHI

PHONETIC

PI

PMT

POISSON

POISSON.DIST

POWER

PPMT

PRICE

PRICEDISC

PRICEMAT

PROB

PRODUCT

PROPER

PV

QUARTILE

QUARTILE.EXC

QUARTILE.INC

QUOTIENT

RADIANS

RAND

RANDBETWEEN

RANK

RANK.AVG

RANK.EQ

RATE

RECEIVED

REGISTER.ID

REPLACE, REPLACEB

REPT

RIGHT, RIGHTB

ROMAN

ROUND

ROUNDDOWN

ROUNDUP

ROW

ROWS

RRI

RSQ

RTD

SEARCH, SEARCHB

SEC

SECH

SECOND

SERIESSUM

SHEET

SHEETS

SIGN

SIN

SINH

SKEW

SKEW.P

SLN

SLOPE

SMALL

SQL.REQUEST

SQRT

SQRTPI

STANDARDIZE

STDEV

STDEV.P

STDEV.S

STDEVA

STDEVP

STDEVPA

STEYX

SUBSTITUTE

SUBTOTAL

SUM

SUMIF

SUMIFS

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

SYD

T

T.DIST

T.DIST.2T

T.DIST.RT

T.INV

T.INV.2T

T.TEST

TAN

TANH

TBILLEQ

TBILLPRICE

TBILLYIELD

TDIST

TEXT

TIME

TIMEVALUE

TINV

TODAY

TRANSPOSE

TREND

TRIM

TRIMMEAN

TRUE

TRUNC

TTEST

TYPE

UNICHAR

UNICODE

UPPER

VALUE

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

VDB

VLOOKUP

WEBSERVICE

WEEKDAY

WEEKNUM

WEIBULL

WEIBULL.DIST

WORKDAY

WORKDAY.INTL

XIRR

XNPV

XOR

YEAR

YEARFRAC

YIELD

YIELDDISC

YIELDMAT

Z.TEST

ZTEST

## The Risk of Vulnerable Functions

Most of the functions mentioned above are rock-solid, but a couple of them we considervulnerable functions. Some of which are frequently used by many Excel professionals. We suggest you try to avoid using them. Excel offers a range of fine alternatives. PerfectXL helps you discover vulnerable Excel functions in your spreadsheet and helps you find the safe(r) alternatives.

## Excel Functions Translated

Excel is available in many different languages. Every Excel function is translated in every available language edition of Excel. Sometimes its hard to remember the names of the functions in different languages. Please use the translation pages below, in case you find yourself working with a different language version of Excel than youre used to:

- English to Dutch
- Dutch to English
- English to Spanish
- Spanish to English
- English to French
- French to English
- English to Portuguese
- Portuguese to English
- English to German
- German to English
- English to Russian
- Russian to English
- English to Turkish
- Turkish to English
- English to Swedish
- Swedish to English
- English to Danish
- Danish to English

## Blog posts for better Excel use:

#### Where is my named range used?

Named Ranges make it clear to users what value is being referred to and it allows you to update it globally if it changes. Only one question remains Where is my Named Range used?Read more

#### How to Keep Formulas Readable

Sometimes a formula can spill over onto 2 or 3 lines making the standard 1 line formula bar too small to read. So how can you make formulas readable?Read more

#### Structure Changes: Columns and Rows

Everyone with even the most basic understanding knows that Excel is made up of columns and rows. In this blog well discuss what happens when you add or delete rows and columns, which happens frequently in Excel and actually changes the very structure of the sheet youre working on.Read more