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
ANDY
AVERAGEPROMEDIO
AVERAGEIFPROMEDIO.SI
AVERAGEIFSPROMEDIO.SI.CONJUNTO
BAHTTEXTTEXTOBAHT
BIN2DECBIN.A.DEC
BIN2HEXBIN.A.HEX
CEILINGMULTIPLO.SUPERIOR
CHARCARACTER
CHOOSEELEGIR
CODECODIGO
COLUMNCOLUMNA
COLUMNSCOLUMNAS
CONCATENATECONCATENAR
COUNTCONTAR
COUNTACONTARA
COUNTBLANKCONTAR.BLANCO
COUNTIFCONTAR.SI
COUNTIFSCONTAR.SI.CONJUNTO
DATEFECHA
DATEVALUEFECHANUMERO
DAYDIA
DEC2BINDEC.A.BIN
DEC2HEXDEC.A.HEX
EOMONTHFIN.MES
EVENREDONDEA.PAR
EXACTIGUAL
FACTFACT
FINDENCONTRAR
FLOORMULTIPLO.INFERIOR
HEX2BINHEX.A.BIN
HEX2DECHEX.A.DEC
HLOOKUPBUSCARH
HYPERLINKHIPERVINCULO
IFSI
IFERRORSI.ERROR
INDEXINDICE
INDIRECTINDIRECTO
INFOINFO
INTENTERO
ISBLANKESBLANCO
ISERRORESERROR
ISEVENES.PAR
ISNAESNOD
ISNONTEXTESNOTEXTO
ISNUMBERESNUMERO
ISODDES.IMPAR
ISTEXTESTEXTO
LARGEK.ESIMO.MAYOR
LEFTIZQUIERDA
LENLARGO
LOOKUPBUSCAR
LOWERMINUSC
MATCHCOINCIDIR
MAXMAX
MEDIANMEDIANA
MIDEXTRAE
MINMIN
MODRESIDUO
MODEMODA
MONTHMES
NN
NAND
NETWORKDAYSDIAS.LAB
NOTNO
NOWAHORA
ODDREDONDEA.IMPAR
OFFSETDESREF
ORO
PERCENTILEPERCENTIL
PIPI
PROPERNOMPROPIO
QUARTILECUARTIL
RANDALEATORIO
RANDBETWEENALEATORIO.ENTRE
RANKJERARQUIA
REPLACEREEMPLAZAR
REPTREPETIR
RIGHTDERECHA
ROMANNUMERO.ROMANO
ROUNDREDONDEAR
ROUNDDOWNREDONDEAR.MENOS
ROUNDUPREDONDEAR.MAS
ROWFILA
ROWSFILAS
SEARCHHALLAR
SMALLK.ESIMO.MENOR
STDEVDESVEST
SUBSTITUTESUSTITUIR
SUMSUMA
SUMIFSUMAR.SI
SUMIFSSUMAR.SI.CONJUNTO
SUMPRODUCTSUMAPRODUCTO
TEXTTEXT
TODAYHOY
TRANSPOSETRANSPONER
TRIMESPACIOS
UPPERMAYUSC
VLOOKUPBUSCARV
WEEKDAYDIASEM
WEEKNUMNUM.DE.SEMANA
YEARAÑO
TRUEVERDADERO

2 thoughts on “Excel Functions in Spanish

Leave a Reply

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


five − 4 =