Excel Functions in Spanish

Funciones de Excel en español

These are the most common Excel functions with Spanish translations.

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

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

2 thoughts on “Excel Functions in Spanish

Leave a Reply

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


6 + = twelve