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.

English	Spanish
ABS	ABS
ADDRESS	DIRECCION
AGGREGATE	AGREGAR
AND	Y
ARABIC	NUMERO.ARABE
AVERAGE	PROMEDIO
AVERAGEIF	PROMEDIO.SI
AVERAGEIFS	PROMEDIO.SI.CONJUNTO
BAHTTEXT	TEXTOBAHT
BIN2DEC	BIN.A.DEC
BIN2HEX	BIN.A.HEX
CEILING	MULTIPLO.SUPERIOR
CEILING.MATH	MULTIPLO.SUPERIOR.MAT
CELL	CELDA
CHAR	CARACTER
CHOOSE	ELEGIR
CODE	CODIGO
COLUMN	COLUMNA
COLUMNS	COLUMNAS
CONCAT	CONCAT
CONCATENATE	CONCATENAR
CONVERT	CONVERTIR
COUNT	CONTAR
COUNTA	CONTARA
COUNTBLANK	CONTAR.BLANCO
COUNTIF	CONTAR.SI
COUNTIFS	CONTAR.SI.CONJUNTO
DATE	FECHA
DATEVALUE	FECHANUMERO
DAY	DIA
DAYS	DIAS
DEC2BIN	DEC.A.BIN
DEC2HEX	DEC.A.HEX
EOMONTH	FIN.MES
EVEN	REDONDEA.PAR
EXACT	IGUAL
FACT	FACT
FILTERXML	XMLFILTRO
FIND	ENCONTRAR
FLOOR	MULTIPLO.INFERIOR
FLOOR.MATH	MULTIPLO.INFERIOR.MAT
FORMULATEXT	FORMULATEXTO
FREQUENCY	FRECUENCIA
HEX2BIN	HEX.A.BIN
HEX2DEC	HEX.A.DEC
HLOOKUP	BUSCARH
HYPERLINK	HIPERVINCULO
IF	SI
IFERROR	SI.ERROR
IFS	SI.CONJUNTO
INDEX	INDICE
INDIRECT	INDIRECTO
INFO	INFO
INT	ENTERO
ISBLANK	ESBLANCO
ISERROR	ESERROR
ISEVEN	ES.PAR
ISLOGICAL	ESLOGICO
ISNA	ESNOD
ISNONTEXT	ESNOTEXTO
ISNUMBER	ESNUMERO
ISODD	ES.IMPAR
ISOWEEKNUM	ISO.NUM.DE.SEMANA
ISTEXT	ESTEXTO
LARGE	K.ESIMO.MAYOR
LEFT	IZQUIERDA
LEN	LARGO
LOOKUP	BUSCAR
LOWER	MINUSC
MATCH	COINCIDIR
MAX	MAX
MAXIFS	MAX.SI.CONJUNTO
MEDIAN	MEDIANA
MID	EXTRAE
MIN	MIN
MINIFS	MIN.SI.CONJUNTO
MOD	RESIDUO
MODE	MODA
MONTH	MES
MROUND	REDOND.MULT
N	N
NA	NOD
NETWORKDAYS	DIAS.LAB
NETWORKDAYS.INTL	DIAS.LAB.INTL
NOT	NO
NOW	AHORA
ODD	REDONDEA.IMPAR
OFFSET	DESREF
OR	O
PERCENTILE	PERCENTIL
PERCENTILE.EXC	PERCENTIL.EXC
PERCENTILE.INC	PERCENTIL.INC
PERCENTRANK	RANGO.PERCENTIL
PERCENTRANK.EXC	RANGO.PERCENTIL.EXC
PERCENTRANK.INC	RANGO.PERCENTIL.INC
PI	PI
PMT	PAGO
PROPER	NOMPROPIO
QUARTILE	CUARTIL
QUARTILE.EXC	CUARTIL.EXC
QUARTILE.INC	CUARTIL.INC
RAND	ALEATORIO
RANDBETWEEN	ALEATORIO.ENTRE
RANK	JERARQUIA
RANK.AVG	JERARQUIA.MEDIA
RANK.EQ	JERARQUIA.EQV
REPLACE	REEMPLAZAR
REPT	REPETIR
RIGHT	DERECHA
ROMAN	NUMERO.ROMANO
ROUND	REDONDEAR
ROUNDDOWN	REDONDEAR.MENOS
ROUNDUP	REDONDEAR.MAS
ROW	FILA
ROWS	FILAS
SEARCH	HALLAR
SMALL	K.ESIMO.MENOR
STDEV	DESVEST
STDEV.P	DESVEST.P
STDEV.S	DESVEST.M
SUBSTITUTE	SUSTITUIR
SUBTOTAL	SUBTOTALES
SUM	SUMA
SUMIF	SUMAR.SI
SUMIFS	SUMAR.SI.CONJUNTO
SUMPRODUCT	SUMAPRODUCTO
SWITCH	CAMBIAR
TEXT	TEXTO
TEXTJOIN	UNIRCADENAS
TODAY	HOY
TRANSPOSE	TRANSPONER
TRIM	ESPACIOS
UNICHAR	UNICAR
UNICODE	UNICODE
UPPER	MAYUSC
VLOOKUP	BUSCARV
WEEKDAY	DIASEM
WEEKNUM	NUM.DE.SEMANA
YEAR	AÑO
FALSE	FALSO
TRUE	VERDADERO

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.

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: