Excel Functions in Spanish

These are the most common Excel functions with Spanish translations.

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


English Spanish
ABS ABS
ADDRESS DIRECCION
AND Y
AVERAGE PROMEDIO
AVERAGEIF PROMEDIO.SI
AVERAGEIFS PROMEDIO.SI.CONJUNTO
BAHTTEXT TEXTOBAHT
BIN2DEC BIN.A.DEC
BIN2HEX BIN.A.HEX
CEILING MULTIPLO.SUPERIOR
CHAR CARACTER
CHOOSE ELEGIR
CODE CODIGO
COLUMN COLUMNA
COLUMNS COLUMNAS
CONCATENATE CONCATENAR
COUNT CONTAR
COUNTA CONTARA
COUNTBLANK CONTAR.BLANCO
COUNTIF CONTAR.SI
COUNTIFS CONTAR.SI.CONJUNTO
DATE FECHA
DATEVALUE FECHANUMERO
DAY DIA
DEC2BIN DEC.A.BIN
DEC2HEX DEC.A.HEX
EOMONTH FIN.MES
EVEN REDONDEA.PAR
EXACT IGUAL
FACT FACT
FIND ENCONTRAR
FLOOR MULTIPLO.INFERIOR
HEX2BIN HEX.A.BIN
HEX2DEC HEX.A.DEC
HLOOKUP BUSCARH
HYPERLINK HIPERVINCULO
IF SI
IFERROR SI.ERROR
INDEX INDICE
INDIRECT INDIRECTO
INFO INFO
INT ENTERO
ISBLANK ESBLANCO
ISERROR ESERROR
ISEVEN ES.PAR
ISNA ESNOD
ISNONTEXT ESNOTEXTO
ISNUMBER ESNUMERO
ISODD ES.IMPAR
ISTEXT ESTEXTO
LARGE K.ESIMO.MAYOR
LEFT IZQUIERDA
LEN LARGO
LOOKUP BUSCAR
LOWER MINUSC
MATCH COINCIDIR
MAX MAX
MEDIAN MEDIANA
MID EXTRAE
MIN MIN
MOD RESIDUO
MODE MODA
MONTH MES
N N
NA ND
NETWORKDAYS DIAS.LAB
NOT NO
NOW AHORA
ODD REDONDEA.IMPAR
OFFSET DESREF
OR O
PERCENTILE PERCENTIL
PI PI
PROPER NOMPROPIO
QUARTILE CUARTIL
RAND ALEATORIO
RANDBETWEEN ALEATORIO.ENTRE
RANK JERARQUIA
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
SUBSTITUTE SUSTITUIR
SUM SUMA
SUMIF SUMAR.SI
SUMIFS SUMAR.SI.CONJUNTO
SUMPRODUCT SUMAPRODUCTO
TEXT TEXT
TODAY HOY
TRANSPOSE TRANSPONER
TRIM ESPACIOS
UPPER MAYUSC
VLOOKUP BUSCARV
WEEKDAY DIASEM
WEEKNUM NUM.DE.SEMANA
YEAR AÑO
TRUE VERDADERO


One thought on “Excel Functions in Spanish

Leave a Reply

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


1 + eight =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>