Browse the function library

Excel Functions by Category

Browse 458 spreadsheet functions grouped by the job they perform. Search by English function name, category, or one of the explicitly mapped French, German and Spanish names in CellLingo’s translation dataset.

458reference functions

12functional categories

91functions with language mappings

Cube7 functions

CUBEKPIMEMBER

Spreadsheet function in the Cube category.

CUBEMEMBER

Spreadsheet function in the Cube category.

CUBEMEMBERPROPERTY

Spreadsheet function in the Cube category.

CUBERANKEDMEMBER

Spreadsheet function in the Cube category.

CUBESET

Spreadsheet function in the Cube category.

CUBESETCOUNT

Spreadsheet function in the Cube category.

CUBEVALUE

Spreadsheet function in the Cube category.

Database12 functions

DAVERAGE

Spreadsheet function in the Database category.

DCOUNT

Spreadsheet function in the Database category.

DCOUNTA

Spreadsheet function in the Database category.

DGET

Spreadsheet function in the Database category.

DMAX

Spreadsheet function in the Database category.

DMIN

Spreadsheet function in the Database category.

DPRODUCT

Spreadsheet function in the Database category.

DSTDEV

Spreadsheet function in the Database category.

DSTDEVP

Spreadsheet function in the Database category.

DSUM

Spreadsheet function in the Database category.

DVAR

Spreadsheet function in the Database category.

DVARP

Spreadsheet function in the Database category.

Date & time25 functions

DATE translated

Builds a date from year, month and day.

Open full guide →

FRDATE DEDATUM ESFECHA

DATEDIF

Spreadsheet function in the Date & time category.

DATEVALUE

Spreadsheet function in the Date & time category.

DAY translated

Returns the day of month.

FRJOUR DETAG ESDIA

DAYS

Spreadsheet function in the Date & time category.

DAYS360

Spreadsheet function in the Date & time category.

EDATE translated

Moves a date by whole months.

FRMOIS.DECALER DEEDATUM ESFECHA.MES

EOMONTH translated

Returns the last day of a month offset.

Open full guide →

FRFIN.MOIS DEMONATSENDE ESFIN.MES

HOUR

Spreadsheet function in the Date & time category.

ISOWEEKNUM

Spreadsheet function in the Date & time category.

MINUTE

Spreadsheet function in the Date & time category.

MONTH translated

Returns the month from a date.

FRMOIS DEMONAT ESMES

NETWORKDAYS translated

Counts working days between dates.

Open full guide →

FRNB.JOURS.OUVRES DENETTOARBEITSTAGE ESDIAS.LAB

NETWORKDAYS.INTL

Spreadsheet function in the Date & time category.

NOW translated

Returns the current date and time.

FRMAINTENANT DEJETZT ESAHORA

SECOND

Spreadsheet function in the Date & time category.

TIME

Spreadsheet function in the Date & time category.

TIMEVALUE

Spreadsheet function in the Date & time category.

TODAY translated

Returns today’s date.

Open full guide →

FRAUJOURDHUI DEHEUTE ESHOY

WEEKDAY translated

Returns the weekday number.

FRJOURSEM DEWOCHENTAG ESDIASEM

WEEKNUM translated

Returns the week number.

FRNO.SEMAINE DEKALENDERWOCHE ESNUM.DE.SEMANA

WORKDAY translated

Returns a workday before or after a date.

FRSERIE.JOUR.OUVRE DEARBEITSTAG ESDIA.LAB

WORKDAY.INTL

Spreadsheet function in the Date & time category.

YEAR translated

Returns the year from a date.

FRANNEE DEJAHR ESAÑO

YEARFRAC

Spreadsheet function in the Date & time category.

Engineering54 functions

BESSELI

Spreadsheet function in the Engineering category.

BESSELJ

Spreadsheet function in the Engineering category.

BESSELK

Spreadsheet function in the Engineering category.

BESSELY

Spreadsheet function in the Engineering category.

BIN2DEC

Spreadsheet function in the Engineering category.

BIN2HEX

Spreadsheet function in the Engineering category.

BIN2OCT

Spreadsheet function in the Engineering category.

BITAND

Spreadsheet function in the Engineering category.

BITLSHIFT

Spreadsheet function in the Engineering category.

BITOR

Spreadsheet function in the Engineering category.

BITRSHIFT

Spreadsheet function in the Engineering category.

BITXOR

Spreadsheet function in the Engineering category.

COMPLEX

Spreadsheet function in the Engineering category.

CONVERT

Spreadsheet function in the Engineering category.

DEC2BIN

Spreadsheet function in the Engineering category.

DEC2HEX

Spreadsheet function in the Engineering category.

DEC2OCT

Spreadsheet function in the Engineering category.

DELTA

Spreadsheet function in the Engineering category.

ERF

Spreadsheet function in the Engineering category.

ERF.PRECISE

Spreadsheet function in the Engineering category.

ERFC

Spreadsheet function in the Engineering category.

ERFC.PRECISE

Spreadsheet function in the Engineering category.

GESTEP

Spreadsheet function in the Engineering category.

HEX2BIN

Spreadsheet function in the Engineering category.

HEX2DEC

Spreadsheet function in the Engineering category.

HEX2OCT

Spreadsheet function in the Engineering category.

IMABS

Spreadsheet function in the Engineering category.

IMAGINARY

Spreadsheet function in the Engineering category.

IMARGUMENT

Spreadsheet function in the Engineering category.

IMCONJUGATE

Spreadsheet function in the Engineering category.

IMCOS

Spreadsheet function in the Engineering category.

IMCOSH

Spreadsheet function in the Engineering category.

IMCOT

Spreadsheet function in the Engineering category.

IMCSC

Spreadsheet function in the Engineering category.

IMCSCH

Spreadsheet function in the Engineering category.

IMDIV

Spreadsheet function in the Engineering category.

IMEXP

Spreadsheet function in the Engineering category.

IMLN

Spreadsheet function in the Engineering category.

IMLOG10

Spreadsheet function in the Engineering category.

IMLOG2

Spreadsheet function in the Engineering category.

IMPOWER

Spreadsheet function in the Engineering category.

IMPRODUCT

Spreadsheet function in the Engineering category.

IMREAL

Spreadsheet function in the Engineering category.

IMSEC

Spreadsheet function in the Engineering category.

IMSECH

Spreadsheet function in the Engineering category.

IMSIN

Spreadsheet function in the Engineering category.

IMSINH

Spreadsheet function in the Engineering category.

IMSQRT

Spreadsheet function in the Engineering category.

IMSUB

Spreadsheet function in the Engineering category.

IMSUM

Spreadsheet function in the Engineering category.

IMTAN

Spreadsheet function in the Engineering category.

OCT2BIN

Spreadsheet function in the Engineering category.

OCT2DEC

Spreadsheet function in the Engineering category.

OCT2HEX

Spreadsheet function in the Engineering category.

Financial55 functions

ACCRINT

Spreadsheet function in the Financial category.

ACCRINTM

Spreadsheet function in the Financial category.

AMORDEGRC

Spreadsheet function in the Financial category.

AMORLINC

Spreadsheet function in the Financial category.

COUPDAYBS

Spreadsheet function in the Financial category.

COUPDAYS

Spreadsheet function in the Financial category.

COUPDAYSNC

Spreadsheet function in the Financial category.

COUPNCD

Spreadsheet function in the Financial category.

COUPNUM

Spreadsheet function in the Financial category.

COUPPCD

Spreadsheet function in the Financial category.

CUMIPMT

Spreadsheet function in the Financial category.

CUMPRINC

Spreadsheet function in the Financial category.

DB

Spreadsheet function in the Financial category.

DDB

Spreadsheet function in the Financial category.

DISC

Spreadsheet function in the Financial category.

DOLLARDE

Spreadsheet function in the Financial category.

DOLLARFR

Spreadsheet function in the Financial category.

DURATION

Spreadsheet function in the Financial category.

EFFECT

Spreadsheet function in the Financial category.

FV

Spreadsheet function in the Financial category.

FVSCHEDULE

Spreadsheet function in the Financial category.

INTRATE

Spreadsheet function in the Financial category.

IPMT

Spreadsheet function in the Financial category.

IRR

Spreadsheet function in the Financial category.

ISPMT

Spreadsheet function in the Financial category.

MDURATION

Spreadsheet function in the Financial category.

MIRR

Spreadsheet function in the Financial category.

NOMINAL

Spreadsheet function in the Financial category.

NPER

Spreadsheet function in the Financial category.

NPV

Spreadsheet function in the Financial category.

ODDFPRICE

Spreadsheet function in the Financial category.

ODDFYIELD

Spreadsheet function in the Financial category.

ODDLPRICE

Spreadsheet function in the Financial category.

ODDLYIELD

Spreadsheet function in the Financial category.

PDURATION

Spreadsheet function in the Financial category.

PMT

Spreadsheet function in the Financial category.

PPMT

Spreadsheet function in the Financial category.

PRICE

Spreadsheet function in the Financial category.

PRICEDISC

Spreadsheet function in the Financial category.

PRICEMAT

Spreadsheet function in the Financial category.

PV

Spreadsheet function in the Financial category.

RATE

Spreadsheet function in the Financial category.

RECEIVED

Spreadsheet function in the Financial category.

RRI

Spreadsheet function in the Financial category.

SLN

Spreadsheet function in the Financial category.

SYD

Spreadsheet function in the Financial category.

TBILLEQ

Spreadsheet function in the Financial category.

TBILLPRICE

Spreadsheet function in the Financial category.

TBILLYIELD

Spreadsheet function in the Financial category.

VDB

Spreadsheet function in the Financial category.

XIRR

Spreadsheet function in the Financial category.

XNPV

Spreadsheet function in the Financial category.

YIELD

Spreadsheet function in the Financial category.

YIELDDISC

Spreadsheet function in the Financial category.

YIELDMAT

Spreadsheet function in the Financial category.

Information21 functions

CELL

Spreadsheet function in the Information category.

ERROR.TYPE

Spreadsheet function in the Information category.

INFO

Spreadsheet function in the Information category.

ISBLANK translated

Tests whether a cell is blank.

FRESTVIDE DEISTLEER ESESBLANCO

ISERR

Spreadsheet function in the Information category.

ISERROR translated

Tests whether a value is an error.

FRESTERREUR DEISTFEHLER ESESERROR

ISEVEN

Spreadsheet function in the Information category.

ISFORMULA

Spreadsheet function in the Information category.

ISLOGICAL

Spreadsheet function in the Information category.

ISNA

Spreadsheet function in the Information category.

ISNONTEXT

Spreadsheet function in the Information category.

ISNUMBER translated

Tests whether a value is numeric.

Open full guide →

FRESTNUM DEISTZAHL ESESNUMERO

ISODD

Spreadsheet function in the Information category.

ISOMITTED

Spreadsheet function in the Information category.

ISREF

Spreadsheet function in the Information category.

ISTEXT translated

Tests whether a value is text.

FRESTTEXTE DEISTTEXT ESESTEXTO

N

Spreadsheet function in the Information category.

NA

Spreadsheet function in the Information category.

SHEET

Spreadsheet function in the Information category.

SHEETS

Spreadsheet function in the Information category.

TYPE

Spreadsheet function in the Information category.

Logical17 functions

AND translated

Returns TRUE when all tests are true.

Open full guide →

FRET DEUND ESY

BYCOL

Spreadsheet function in the Logical category.

BYROW

Spreadsheet function in the Logical category.

FALSE

Spreadsheet function in the Logical category.

IF translated

Returns one value when a test is true and another when false.

Open full guide →

FRSI DEWENN ESSI

IFERROR translated

Returns a fallback value when a formula errors.

Open full guide →

FRSIERREUR DEWENNFEHLER ESSI.ERROR

IFNA translated

Returns a fallback when #N/A occurs.

FRSI.NON.DISP DEWENNNV ESSI.ND

IFS translated

Tests multiple conditions in order.

FRSI.CONDITIONS DEWENNS ESSI.CONJUNTO

LAMBDA

Spreadsheet function in the Logical category.

LET translated

Assigns names to calculation results inside a formula.

Open full guide →

FRNOMMER DELET ESLET

NOT translated

Reverses a logical value.

FRNON DENICHT ESNO

OR translated

Returns TRUE when any test is true.

Open full guide →

FROU DEODER ESO

REDUCE

Spreadsheet function in the Logical category.

SCAN

Spreadsheet function in the Logical category.

SWITCH translated

Matches a value against a list of cases.

FRCHOISIR.SI DEERSTERWERT ESCAMBIAR

TRUE

Spreadsheet function in the Logical category.

XOR translated

Returns TRUE when an odd number of tests are true.

FROUX DEXODER ESXO

Lookup & reference37 functions

ADDRESS

Spreadsheet function in the Lookup & reference category.

AREAS

Spreadsheet function in the Lookup & reference category.

CHOOSE translated

Chooses a value from a list by index.

FRCHOISIR DEWAHL ESELEGIR

CHOOSECOLS

Spreadsheet function in the Lookup & reference category.

CHOOSEROWS

Spreadsheet function in the Lookup & reference category.

COLUMN translated

Returns a column number.

FRCOLONNE DESPALTE ESCOLUMNA

COLUMNS translated

Returns the number of columns in a reference.

FRCOLONNES DESPALTEN ESCOLUMNAS

DROP

Spreadsheet function in the Lookup & reference category.

EXPAND

Spreadsheet function in the Lookup & reference category.

FILTER translated

Filters a range using criteria.

Open full guide →

FRFILTRE DEFILTER ESFILTRAR

FORMULATEXT translated

Returns a formula as text.

FRFORMULETEXTE DEFORMELTEXT ESFORMULATEXTO

GETPIVOTDATA

Spreadsheet function in the Lookup & reference category.

HLOOKUP translated

Looks horizontally in the first row of a table.

FRRECHERCHEH DEWVERWEIS ESBUSCARH

HSTACK

Spreadsheet function in the Lookup & reference category.

HYPERLINK translated

Creates a clickable hyperlink.

Open full guide →

FRLIEN_HYPERTEXTE DEHYPERLINK ESHIPERVINCULO

IMAGE

Spreadsheet function in the Lookup & reference category.

INDEX translated

Returns a value at a row and column position.

Open full guide →

FRINDEX DEINDEX ESINDICE

INDIRECT translated

Builds a reference from text.

FRINDIRECT DEINDIREKT ESINDIRECTO

LOOKUP translated

Looks up a value in a vector or array.

FRRECHERCHE DEVERWEIS ESBUSCAR

MATCH translated

Returns the relative position of a value.

Open full guide →

FREQUIV DEVERGLEICH ESCOINCIDIR

OFFSET translated

Returns a reference offset from a starting cell.

FRDECALER DEBEREICH.VERSCHIEBEN ESDESREF

ROW translated

Returns a row number.

FRLIGNE DEZEILE ESFILA

ROWS translated

Returns the number of rows in a reference.

FRLIGNES DEZEILEN ESFILAS

RTD

Spreadsheet function in the Lookup & reference category.

SORT translated

Sorts a range or array.

Open full guide →

FRTRIER DESORTIEREN ESORDENAR

SORTBY

Spreadsheet function in the Lookup & reference category.

TAKE

Spreadsheet function in the Lookup & reference category.

TOCOL

Spreadsheet function in the Lookup & reference category.

TOROW

Spreadsheet function in the Lookup & reference category.

TRANSPOSE translated

Switches rows and columns.

Open full guide →

FRTRANSPOSE DEMTRANS ESTRANSPONER

UNIQUE translated

Returns unique values.

Open full guide →

FRUNIQUE DEEINDEUTIG ESUNICOS

VLOOKUP translated

Looks vertically in the first column of a table.

Open full guide →

FRRECHERCHEV DESVERWEIS ESBUSCARV

VSTACK

Spreadsheet function in the Lookup & reference category.

WRAPCOLS

Spreadsheet function in the Lookup & reference category.

WRAPROWS

Spreadsheet function in the Lookup & reference category.

XLOOKUP translated

Looks up a value in a range and returns a corresponding result.

Open full guide →

FRRECHERCHEX DEXVERWEIS ESBUSCARX

XMATCH translated

Modern match function with flexible search modes.

FRXEQUIV DEXVERGLEICH ESCOINCIDIRX

Math & trigonometry80 functions

ABS translated

Returns the absolute value.

FRABS DEABS ESABS

ACOS

Spreadsheet function in the Math & trigonometry category.

ACOSH

Spreadsheet function in the Math & trigonometry category.

ACOT

Spreadsheet function in the Math & trigonometry category.

ACOTH

Spreadsheet function in the Math & trigonometry category.

AGGREGATE

Spreadsheet function in the Math & trigonometry category.

ARABIC

Spreadsheet function in the Math & trigonometry category.

ASIN

Spreadsheet function in the Math & trigonometry category.

ASINH

Spreadsheet function in the Math & trigonometry category.

ATAN

Spreadsheet function in the Math & trigonometry category.

ATAN2

Spreadsheet function in the Math & trigonometry category.

ATANH

Spreadsheet function in the Math & trigonometry category.

BASE

Spreadsheet function in the Math & trigonometry category.

CEILING

Spreadsheet function in the Math & trigonometry category.

CEILING.MATH

Spreadsheet function in the Math & trigonometry category.

CEILING.PRECISE

Spreadsheet function in the Math & trigonometry category.

COMBIN

Spreadsheet function in the Math & trigonometry category.

COMBINA

Spreadsheet function in the Math & trigonometry category.

COS

Spreadsheet function in the Math & trigonometry category.

COSH

Spreadsheet function in the Math & trigonometry category.

COT

Spreadsheet function in the Math & trigonometry category.

COTH

Spreadsheet function in the Math & trigonometry category.

CSC

Spreadsheet function in the Math & trigonometry category.

CSCH

Spreadsheet function in the Math & trigonometry category.

DECIMAL

Spreadsheet function in the Math & trigonometry category.

DEGREES

Spreadsheet function in the Math & trigonometry category.

EVEN

Spreadsheet function in the Math & trigonometry category.

EXP

Spreadsheet function in the Math & trigonometry category.

FACT

Spreadsheet function in the Math & trigonometry category.

FACTDOUBLE

Spreadsheet function in the Math & trigonometry category.

FLOOR

Spreadsheet function in the Math & trigonometry category.

FLOOR.MATH

Spreadsheet function in the Math & trigonometry category.

FLOOR.PRECISE

Spreadsheet function in the Math & trigonometry category.

GCD

Spreadsheet function in the Math & trigonometry category.

INT translated

Rounds a number down to an integer.

FRENT DEGANZZAHL ESENTERO

ISO.CEILING

Spreadsheet function in the Math & trigonometry category.

LCM

Spreadsheet function in the Math & trigonometry category.

LN

Spreadsheet function in the Math & trigonometry category.

LOG

Spreadsheet function in the Math & trigonometry category.

LOG10

Spreadsheet function in the Math & trigonometry category.

MDETERM

Spreadsheet function in the Math & trigonometry category.

MINVERSE

Spreadsheet function in the Math & trigonometry category.

MMULT

Spreadsheet function in the Math & trigonometry category.

MOD translated

Returns the remainder after division.

FRMOD DEREST ESRESIDUO

MROUND

Spreadsheet function in the Math & trigonometry category.

MULTINOMIAL

Spreadsheet function in the Math & trigonometry category.

MUNIT

Spreadsheet function in the Math & trigonometry category.

ODD

Spreadsheet function in the Math & trigonometry category.

PI

Spreadsheet function in the Math & trigonometry category.

POWER translated

Raises a number to a power.

FRPUISSANCE DEPOTENZ ESPOTENCIA

PRODUCT translated

Multiplies supplied numbers.

FRPRODUIT DEPRODUKT ESPRODUCTO

QUOTIENT

Spreadsheet function in the Math & trigonometry category.

RADIANS

Spreadsheet function in the Math & trigonometry category.

RAND translated

Returns a random number between 0 and 1.

FRALEA DEZUFALLSZAHL ESALEATORIO

RANDARRAY

Spreadsheet function in the Math & trigonometry category.

RANDBETWEEN translated

Returns a random integer between two values.

FRALEA.ENTRE.BORNES DEZUFALLSBEREICH ESALEATORIO.ENTRE

ROMAN

Spreadsheet function in the Math & trigonometry category.

ROUND translated

Rounds a number to a specified number of digits.

Open full guide →

FRARRONDI DERUNDEN ESREDONDEAR

ROUNDDOWN translated

Rounds toward zero.

FRARRONDI.INF DEABRUNDEN ESREDONDEAR.MENOS

ROUNDUP translated

Rounds away from zero.

FRARRONDI.SUP DEAUFRUNDEN ESREDONDEAR.MAS

SEC

Spreadsheet function in the Math & trigonometry category.

SECH

Spreadsheet function in the Math & trigonometry category.

SERIESSUM

Spreadsheet function in the Math & trigonometry category.

SIGN

Spreadsheet function in the Math & trigonometry category.

SIN

Spreadsheet function in the Math & trigonometry category.

SINH

Spreadsheet function in the Math & trigonometry category.

SQRT translated

Returns a square root.

FRRACINE DEWURZEL ESRAIZ

SQRTPI

Spreadsheet function in the Math & trigonometry category.

SUBTOTAL translated

Calculates a subtotal while optionally ignoring hidden rows.

Open full guide →

FRSOUS.TOTAL DETEILERGEBNIS ESSUBTOTALES

SUM translated

Adds numbers or ranges.

Open full guide →

FRSOMME DESUMME ESSUMA

SUMIF translated

Adds values matching one condition.

FRSOMME.SI DESUMMEWENN ESSUMAR.SI

SUMIFS translated

Adds values matching multiple conditions.

Open full guide →

FRSOMME.SI.ENS DESUMMEWENNS ESSUMAR.SI.CONJUNTO

SUMPRODUCT translated

Multiplies corresponding values and returns their sum.

FRSOMMEPROD DESUMMENPRODUKT ESSUMAPRODUCTO

SUMSQ

Spreadsheet function in the Math & trigonometry category.

SUMX2MY2

Spreadsheet function in the Math & trigonometry category.

SUMX2PY2

Spreadsheet function in the Math & trigonometry category.

SUMXMY2

Spreadsheet function in the Math & trigonometry category.

TAN

Spreadsheet function in the Math & trigonometry category.

TANH

Spreadsheet function in the Math & trigonometry category.

TRUNC translated

Truncates a number to a set number of digits.

FRTRONQUE DEKÜRZEN ESTRUNCAR

Statistical110 functions

AVEDEV

Spreadsheet function in the Statistical category.

AVERAGE translated

Returns the arithmetic mean.

Open full guide →

FRMOYENNE DEMITTELWERT ESPROMEDIO

AVERAGEA

Spreadsheet function in the Statistical category.

AVERAGEIF translated

Averages values matching one condition.

FRMOYENNE.SI DEMITTELWERTWENN ESPROMEDIO.SI

AVERAGEIFS translated

Averages values matching multiple conditions.

FRMOYENNE.SI.ENS DEMITTELWERTWENNS ESPROMEDIO.SI.CONJUNTO

BETA.DIST

Spreadsheet function in the Statistical category.

BETA.INV

Spreadsheet function in the Statistical category.

BINOM.DIST

Spreadsheet function in the Statistical category.

BINOM.DIST.RANGE

Spreadsheet function in the Statistical category.

BINOM.INV

Spreadsheet function in the Statistical category.

CHISQ.DIST

Spreadsheet function in the Statistical category.

CHISQ.DIST.RT

Spreadsheet function in the Statistical category.

CHISQ.INV

Spreadsheet function in the Statistical category.

CHISQ.INV.RT

Spreadsheet function in the Statistical category.

CHISQ.TEST

Spreadsheet function in the Statistical category.

CONFIDENCE.NORM

Spreadsheet function in the Statistical category.

CONFIDENCE.T

Spreadsheet function in the Statistical category.

CORREL

Spreadsheet function in the Statistical category.

COUNT translated

Counts cells containing numbers.

FRNB DEANZAHL ESCONTAR

COUNTA translated

Counts non-empty cells.

FRNBVAL DEANZAHL2 ESCONTARA

COUNTBLANK

Spreadsheet function in the Statistical category.

COUNTIF translated

Counts cells matching one condition.

Open full guide →

FRNB.SI DEZÄHLENWENN ESCONTAR.SI

COUNTIFS translated

Counts cells matching multiple conditions.

FRNB.SI.ENS DEZÄHLENWENNS ESCONTAR.SI.CONJUNTO

COVARIANCE.P

Spreadsheet function in the Statistical category.

COVARIANCE.S

Spreadsheet function in the Statistical category.

DEVSQ

Spreadsheet function in the Statistical category.

EXPON.DIST

Spreadsheet function in the Statistical category.

F.DIST

Spreadsheet function in the Statistical category.

F.DIST.RT

Spreadsheet function in the Statistical category.

F.INV

Spreadsheet function in the Statistical category.

F.INV.RT

Spreadsheet function in the Statistical category.

F.TEST

Spreadsheet function in the Statistical category.

FISHER

Spreadsheet function in the Statistical category.

FISHERINV

Spreadsheet function in the Statistical category.

FORECAST.ETS

Spreadsheet function in the Statistical category.

FORECAST.ETS.CONFINT

Spreadsheet function in the Statistical category.

FORECAST.ETS.SEASONALITY

Spreadsheet function in the Statistical category.

FORECAST.ETS.STAT

Spreadsheet function in the Statistical category.

FORECAST.LINEAR

Spreadsheet function in the Statistical category.

FREQUENCY

Spreadsheet function in the Statistical category.

GAMMA

Spreadsheet function in the Statistical category.

GAMMA.DIST

Spreadsheet function in the Statistical category.

GAMMA.INV

Spreadsheet function in the Statistical category.

GAMMALN

Spreadsheet function in the Statistical category.

GAMMALN.PRECISE

Spreadsheet function in the Statistical category.

GAUSS

Spreadsheet function in the Statistical category.

GEOMEAN

Spreadsheet function in the Statistical category.

GROWTH

Spreadsheet function in the Statistical category.

HARMEAN

Spreadsheet function in the Statistical category.

HYPGEOM.DIST

Spreadsheet function in the Statistical category.

INTERCEPT

Spreadsheet function in the Statistical category.

KURT

Spreadsheet function in the Statistical category.

LARGE translated

Returns the k-th largest value.

FRGRANDE.VALEUR DEKGRÖSSTE ESK.ESIMO.MAYOR

LINEST

Spreadsheet function in the Statistical category.

LOGEST

Spreadsheet function in the Statistical category.

LOGNORM.DIST

Spreadsheet function in the Statistical category.

LOGNORM.INV

Spreadsheet function in the Statistical category.

MAX translated

Returns the largest value.

FRMAX DEMAX ESMAX

MAXA

Spreadsheet function in the Statistical category.

MAXIFS

Spreadsheet function in the Statistical category.

MEDIAN translated

Returns the median.

FRMEDIANE DEMEDIAN ESMEDIANA

MIN translated

Returns the smallest value.

FRMIN DEMIN ESMIN

MINA

Spreadsheet function in the Statistical category.

MINIFS

Spreadsheet function in the Statistical category.

MODE.MULT

Spreadsheet function in the Statistical category.

MODE.SNGL

Spreadsheet function in the Statistical category.

NEGBINOM.DIST

Spreadsheet function in the Statistical category.

NORM.DIST

Spreadsheet function in the Statistical category.

NORM.INV

Spreadsheet function in the Statistical category.

NORM.S.DIST

Spreadsheet function in the Statistical category.

NORM.S.INV

Spreadsheet function in the Statistical category.

PEARSON

Spreadsheet function in the Statistical category.

PERCENTILE.EXC

Spreadsheet function in the Statistical category.

PERCENTILE.INC

Spreadsheet function in the Statistical category.

PERCENTRANK.EXC

Spreadsheet function in the Statistical category.

PERCENTRANK.INC

Spreadsheet function in the Statistical category.

PERMUT

Spreadsheet function in the Statistical category.

PERMUTATIONA

Spreadsheet function in the Statistical category.

PHI

Spreadsheet function in the Statistical category.

POISSON.DIST

Spreadsheet function in the Statistical category.

PROB

Spreadsheet function in the Statistical category.

QUARTILE.EXC

Spreadsheet function in the Statistical category.

QUARTILE.INC

Spreadsheet function in the Statistical category.

RANK.AVG

Spreadsheet function in the Statistical category.

RANK.EQ

Spreadsheet function in the Statistical category.

RSQ

Spreadsheet function in the Statistical category.

SKEW

Spreadsheet function in the Statistical category.

SKEW.P

Spreadsheet function in the Statistical category.

SLOPE

Spreadsheet function in the Statistical category.

SMALL translated

Returns the k-th smallest value.

FRPETITE.VALEUR DEKKLEINSTE ESK.ESIMO.MENOR

STANDARDIZE

Spreadsheet function in the Statistical category.

STDEV.P

Spreadsheet function in the Statistical category.

STDEV.S

Spreadsheet function in the Statistical category.

STDEVA

Spreadsheet function in the Statistical category.

STDEVPA

Spreadsheet function in the Statistical category.

STEYX

Spreadsheet function in the Statistical category.

T.DIST

Spreadsheet function in the Statistical category.

T.DIST.2T

Spreadsheet function in the Statistical category.

T.DIST.RT

Spreadsheet function in the Statistical category.

T.INV

Spreadsheet function in the Statistical category.

T.INV.2T

Spreadsheet function in the Statistical category.

T.TEST

Spreadsheet function in the Statistical category.

TREND

Spreadsheet function in the Statistical category.

TRIMMEAN

Spreadsheet function in the Statistical category.

VAR.P

Spreadsheet function in the Statistical category.

VAR.S

Spreadsheet function in the Statistical category.

VARA

Spreadsheet function in the Statistical category.

VARPA

Spreadsheet function in the Statistical category.

WEIBULL.DIST

Spreadsheet function in the Statistical category.

Z.TEST

Spreadsheet function in the Statistical category.

Text37 functions

ARRAYTOTEXT

Spreadsheet function in the Text category.

ASC

Spreadsheet function in the Text category.

BAHTTEXT

Spreadsheet function in the Text category.

CHAR

Spreadsheet function in the Text category.

CLEAN

Spreadsheet function in the Text category.

CODE

Spreadsheet function in the Text category.

CONCAT

Spreadsheet function in the Text category.

CONCATENATE

Spreadsheet function in the Text category.

DBCS

Spreadsheet function in the Text category.

DOLLAR

Spreadsheet function in the Text category.

EXACT

Spreadsheet function in the Text category.

FIND translated

Finds case-sensitive text.

FRTROUVE DEFINDEN ESENCONTRAR

FIXED

Spreadsheet function in the Text category.

LEFT translated

Returns characters from the start of text.

Open full guide →

FRGAUCHE DELINKS ESIZQUIERDA

LEN translated

Returns the number of characters in text.

FRNBCAR DELÄNGE ESLARGO

LOWER translated

Converts text to lowercase.

FRMINUSCULE DEKLEIN ESMINUSC

MID translated

Returns characters from the middle of text.

Open full guide →

FRSTXT DETEIL ESEXTRAE

NUMBERVALUE

Spreadsheet function in the Text category.

PHONETIC

Spreadsheet function in the Text category.

PROPER translated

Capitalizes words.

FRNOMPROPRE DEGROSS2 ESNOMPROPIO

REPLACE translated

Replaces text by position.

FRREMPLACER DEERSETZEN ESREEMPLAZAR

REPT

Spreadsheet function in the Text category.

RIGHT translated

Returns characters from the end of text.

Open full guide →

FRDROITE DERECHTS ESDERECHA

SEARCH translated

Finds text without case sensitivity.

FRCHERCHE DESUCHEN ESHALLAR

SUBSTITUTE translated

Replaces matching text.

FRSUBSTITUE DEWECHSELN ESSUSTITUIR

T

Spreadsheet function in the Text category.

TEXT translated

Formats a value as text.

FRTEXTE DETEXT ESTEXTO

TEXTAFTER

Spreadsheet function in the Text category.

TEXTBEFORE

Spreadsheet function in the Text category.

TEXTJOIN translated

Joins text with a delimiter.

Open full guide →

FRJOINDRE.TEXTE DETEXTVERKETTEN ESUNIRCADENAS

TEXTSPLIT

Spreadsheet function in the Text category.

TRIM translated

Removes extra spaces from text.

Open full guide →

FRSUPPRESPACE DEGLÄTTEN ESESPACIOS

UNICHAR

Spreadsheet function in the Text category.

UNICODE

Spreadsheet function in the Text category.

UPPER translated

Converts text to uppercase.

FRMAJUSCULE DEGROSS ESMAYUSC

VALUE translated

Converts text representing a number into a number.

FRCNUM DEWERT ESVALOR

VALUETOTEXT

Spreadsheet function in the Text category.

Web3 functions

ENCODEURL

Spreadsheet function in the Web category.

FILTERXML

Spreadsheet function in the Web category.

WEBSERVICE

Spreadsheet function in the Web category.

How the categories help

Function names are much easier to learn when they are grouped by purpose. Lookup functions solve reference and retrieval problems; logical functions make decisions; text functions clean and reshape strings; date and time functions work with serial dates; and statistical or financial functions answer different types of numeric questions.

Start with the task

If you know what you are trying to do but not the function name, open the closest category and scan the function list before searching the entire library.

Use translations carefully

CellLingo shows localized names only when an explicit mapping exists in its translation dataset. A missing translation badge does not mean the function is unavailable in another language.

Open deeper guides

Linked function names have expanded CellLingo guides with syntax, arguments, examples, common mistakes and related functions.

Check your version

Newer functions such as XLOOKUP, FILTER, LET and other dynamic-array functions may require a recent Excel or spreadsheet version.

Need to debug a formula instead of browsing functions? Use the Formula Checker. Need localized function names? Use the Translation Table.