Excel Functions in Catalan

These are the 140 most common functions in Excel with Catalan translations. This list is very useful if you are used to the English version of Excel, and you are working with a Catalan version that only accepts the Catalan function names in the formulas. Or the other way around!

Funcions d’Excel en català

Normally you would also have to replace all the commas in my example formulas with semi-colon.

EnglishCatalan
ABSABS
ADDRESSADREÇA
AGGREGATEVALOR.AFEGIT
ANDI
ARABICARAB
AVERAGEMITJANA
AVERAGEIFMITJANA.SI
AVERAGEIFSMITJANA.SI.CONJUNT
BAHTTEXTTEXTBAHT
BIN2DECBIN.A.DEC
BIN2HEXBIN.A.HEX
CEILINGMULTIPLE.SUPERIOR
CEILING.MATHMULTIPLE.SUPERIOR.MAT
CELLCEL
CHARCAR
CHOOSETRIA
CODECODI
COLUMNCOLUMNA
COLUMNSCOLUMNES
CONCATCONCAT
CONCATENATECONCATENA
CONVERTCONVERT
COUNTCOMPT
COUNTACOMPTAA
COUNTBLANKCOMPTA.BLANC
COUNTIFCOMPTA.SI
COUNTIFSCOMPTE.SI.CONJUNT
DATEDATA
DATEVALUEVALDATA
DAYDIA
DAYSDIES
DEC2BINDEC.A.BIN
DEC2HEXDEC.A.HEX
EOMONTHFIN.MES
EVENPARELL
EXACTIGUAL
FACTFACT
FILTERXMLFILTREXML
FINDBUSCA
FLOORMULTIPLE.INFERIOR
FLOOR.MATHMULTIPLE.INFERIOR.MAT
FORMULATEXTTEXTFORMULA
FREQUENCYFREQUENCIA
HEX2BINHEX.A.BIN
HEX2DECHEX.A.DEC
HLOOKUPCONSULH
HYPERLINKENLLAÇ
IFSI
IFERRORSIERROR
IFSSI.CONJUNT
INDEXINDEX
INDIRECTINDIRECTE
INFOINFO
INTENTER
ISBLANKESBLANC
ISERRORESERROR
ISEVENES.PAR
ISLOGICALESLOGIC
ISNAESND
ISNONTEXTESNOTEXT
ISNUMBERESNUM
ISODDES.IMPAR
ISOWEEKNUMNUM.DE.SEMANA.ISO
ISTEXTESTEXT
LARGEMAJOR
LEFTESQUERRA
LENLLARG
LOOKUPCONSULTA
LOWERMINUSC
MATCHCOINCIDEIX
MAXMAX
MAXIFSMAX.SI.CONJUNT
MEDIANMEDIANA
MIDMIG
MINMIN
MINIFSMIN.SI.CONJUNT
MODRESIDU
MODEMODA
MONTHMES
MROUNDREDOND.MULT
NN
NAND
NETWORKDAYSDIAS.LAB
NETWORKDAYS.INTLDIES.LAB.INTL
NOTNO
NOWACTUAL
ODDSENAR
OFFSETDESPLAÇAMENT
ORO
PERCENTILEPERCENTIL
PERCENTILE.EXCPERCENTIL.EXC
PERCENTILE.INCPERCENTIL.INC
PERCENTRANKRANG.PERCENTIL
PERCENTRANK.EXCRANG.PERCENTIL.EXC
PERCENTRANK.INCRANG.PERCENTIL.INC
PIPI
PMTPAGAMENT
PROPERNOMPROPI
QUARTILEQUARTI
QUARTILE.EXCQUARTI.EXC
QUARTILE.INCQUARTI.INC
RANDALEAT
RANDBETWEENALEATORIO.ENTRE
RANKJERARQUIA
RANK.AVGJERARQUIA.MITJANA
RANK.EQJERARQUIA.EQV
REPLACEREEMPLAÇA
REPTREPETEIX
RIGHTDRETA
ROMANNUMERO.ROMA
ROUNDARRODONEIX
ROUNDDOWNARRODONEIX.MENYS
ROUNDUPARRODONEIX.MES
ROWFILA
ROWSFILES
SEARCHCERCAR
SMALLMENOR
STDEVDESVEST
STDEV.PDESVEST.P
STDEV.SDESVEST.M
SUBSTITUTESUBSTITUEIX
SUBTOTALSUBTOTAL
SUMSUMA
SUMIFSUMA.SI
SUMIFSSUMA.SI.CONJUNT
SUMPRODUCTSUMAPRODUCTE
SWITCHCANVIA
TEXTTEXT
TEXTJOINUNEIXCADENES
TODAYAVUI
TRANSPOSETRANSPOSA
TRIMRETALLA
UNICHARUNICAR
UNICODEUNICODE
UPPERMAJUSC
VLOOKUPCONSULV
WEEKDAYDIASETM
WEEKNUMNUM.DE.SEMANA
YEARANY
FALSEFALS
TRUECERT