Excel Functions in Spanish

Funciones de Excel en español

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

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

Do you need a complete list of all the function names in Spanish in Excel? Scroll down to the bottom of this page to read more about Microsoft’s Functions Translator add-in.

EnglishSpanish
ABSABS
ADDRESSDIRECCION
AGGREGATEAGREGAR
ANDY
ARABICNUMERO.ARABE
AVERAGEPROMEDIO
AVERAGEIFPROMEDIO.SI
AVERAGEIFSPROMEDIO.SI.CONJUNTO
BAHTTEXTTEXTOBAHT
BIN2DECBIN.A.DEC
BIN2HEXBIN.A.HEX
CEILINGMULTIPLO.SUPERIOR
CEILING.MATHMULTIPLO.SUPERIOR.MAT
CELLCELDA
CHARCARACTER
CHOOSEELEGIR
CODECODIGO
COLUMNCOLUMNA
COLUMNSCOLUMNAS
CONCATCONCAT
CONCATENATECONCATENAR
CONVERTCONVERTIR
COUNTCONTAR
COUNTACONTARA
COUNTBLANKCONTAR.BLANCO
COUNTIFCONTAR.SI
COUNTIFSCONTAR.SI.CONJUNTO
DATEFECHA
DATEVALUEFECHANUMERO
DAYDIA
DAYSDIAS
DEC2BINDEC.A.BIN
DEC2HEXDEC.A.HEX
EOMONTHFIN.MES
EVENREDONDEA.PAR
EXACTIGUAL
FACTFACT
FILTERXMLXMLFILTRO
FINDENCONTRAR
FLOORMULTIPLO.INFERIOR
FLOOR.MATHMULTIPLO.INFERIOR.MAT
FORMULATEXTFORMULATEXTO
FREQUENCYFRECUENCIA
HEX2BINHEX.A.BIN
HEX2DECHEX.A.DEC
HLOOKUPBUSCARH
HYPERLINKHIPERVINCULO
IFSI
IFERRORSI.ERROR
IFSSI.CONJUNTO
INDEXINDICE
INDIRECTINDIRECTO
INFOINFO
INTENTERO
ISBLANKESBLANCO
ISERRORESERROR
ISEVENES.PAR
ISLOGICALESLOGICO
ISNAESNOD
ISNONTEXTESNOTEXTO
ISNUMBERESNUMERO
ISODDES.IMPAR
ISOWEEKNUMISO.NUM.DE.SEMANA
ISTEXTESTEXTO
LARGEK.ESIMO.MAYOR
LEFTIZQUIERDA
LENLARGO
LOOKUPBUSCAR
LOWERMINUSC
MATCHCOINCIDIR
MAXMAX
MAXIFSMAX.SI.CONJUNTO
MEDIANMEDIANA
MIDEXTRAE
MINMIN
MINIFSMIN.SI.CONJUNTO
MODRESIDUO
MODEMODA
MONTHMES
MROUNDREDOND.MULT
NN
NANOD
NETWORKDAYSDIAS.LAB
NETWORKDAYS.INTLDIAS.LAB.INTL
NOTNO
NOWAHORA
ODDREDONDEA.IMPAR
OFFSETDESREF
ORO
PERCENTILEPERCENTIL
PERCENTILE.EXCPERCENTIL.EXC
PERCENTILE.INCPERCENTIL.INC
PERCENTRANKRANGO.PERCENTIL
PERCENTRANK.EXCRANGO.PERCENTIL.EXC
PERCENTRANK.INCRANGO.PERCENTIL.INC
PIPI
PMTPAGO
PROPERNOMPROPIO
QUARTILECUARTIL
QUARTILE.EXCCUARTIL.EXC
QUARTILE.INCCUARTIL.INC
RANDALEATORIO
RANDBETWEENALEATORIO.ENTRE
RANKJERARQUIA
RANK.AVGJERARQUIA.MEDIA
RANK.EQJERARQUIA.EQV
REPLACEREEMPLAZAR
REPTREPETIR
RIGHTDERECHA
ROMANNUMERO.ROMANO
ROUNDREDONDEAR
ROUNDDOWNREDONDEAR.MENOS
ROUNDUPREDONDEAR.MAS
ROWFILA
ROWSFILAS
SEARCHHALLAR
SMALLK.ESIMO.MENOR
STDEVDESVEST
STDEV.PDESVEST.P
STDEV.SDESVEST.M
SUBSTITUTESUSTITUIR
SUBTOTALSUBTOTALES
SUMSUMA
SUMIFSUMAR.SI
SUMIFSSUMAR.SI.CONJUNTO
SUMPRODUCTSUMAPRODUCTO
SWITCHCAMBIAR
TEXTTEXTO
TEXTJOINUNIRCADENAS
TODAYHOY
TRANSPOSETRANSPONER
TRIMESPACIOS
UNICHARUNICAR
UNICODEUNICODE
UPPERMAYUSC
VLOOKUPBUSCARV
WEEKDAYDIASEM
WEEKNUMNUM.DE.SEMANA
YEARAÑO
FALSEFALSO
TRUEVERDADERO

Does Excel have a translate function?

Yes, there is an add-in called the Functions Translator add-in that you can install in a few seconds:

Go to Insert > Get Add-ins to open the add-in dialog. Choose Productivity under Category, find the Functions Translator add-in and click on the Add button.

Click on picture to magnify

Now you will find the Functions Translator on the Home tab to the right.

Use it to look up a functions name in a list (Reference):

Or use the Translator feature to translate a whole formula:

3 thoughts on “Excel Functions in Spanish

Leave a Reply

Your email address will not be published. Required fields are marked *


four − = 0