Spanish versions of Excel translate function names, so a formula copied from an English tutorial returns #¿NOMBRE? until the names are translated. The list below covers common functions. Arguments are separated by a semicolon or a comma depending on your regional settings.
Translate a whole formula with FormulaCheck.
Common Excel errors
All functions
| English | Spanish | |
|---|---|---|
ABS | ABS | |
ADDRESS | DIRECCION | |
AGGREGATE | AGREGAR | |
AND | Y | details |
AVERAGE | PROMEDIO | details |
AVERAGEIF | PROMEDIO.SI | |
AVERAGEIFS | PROMEDIO.SI.CONJUNTO | |
CEILING | MULTIPLO.SUPERIOR | |
CELL | CELDA | |
CHOOSE | ELEGIR | |
CLEAN | LIMPIAR | |
COLUMN | COLUMNA | |
COLUMNS | COLUMNAS | |
CONCAT | CONCAT | |
CONCATENATE | CONCATENAR | details |
COUNT | CONTAR | details |
COUNTA | CONTARA | |
COUNTBLANK | CONTAR.BLANCO | |
COUNTIF | CONTAR.SI | details |
COUNTIFS | CONTAR.SI.CONJUNTO | details |
DATE | FECHA | details |
DATEDIF | SIFECHA | |
DATEVALUE | FECHANUMERO | |
DAY | DIA | |
EDATE | FECHA.MES | |
EOMONTH | FIN.MES | |
EXACT | IGUAL | |
FALSE | FALSO | |
FILTER | FILTRAR | |
FIND | ENCONTRAR | |
FLOOR | MULTIPLO.INFERIOR | |
FV | VF | |
HLOOKUP | BUSCARH | details |
HOUR | HORA | |
HSTACK | APILARH | |
HYPERLINK | HIPERVINCULO | |
IF | SI | details |
IFERROR | SI.ERROR | details |
IFNA | SI.ND | |
IFS | SI.CONJUNTO | details |
INDEX | INDICE | details |
INDIRECT | INDIRECTO | |
INT | ENTERO | |
IRR | TIR | |
ISBLANK | ESBLANCO | |
ISERR | ESERR | |
ISERROR | ESERROR | |
ISEVEN | ES.PAR | |
ISLOGICAL | ESLOGICO | |
ISNA | ESNOD | |
ISNUMBER | ESNUMERO | |
ISODD | ES.IMPAR | |
ISTEXT | ESTEXTO | |
LAMBDA | LAMBDA | |
LARGE | K.ESIMO.MAYOR | |
LEFT | IZQUIERDA | details |
LEN | LARGO | details |
LET | LET | |
LOOKUP | BUSCAR | |
LOWER | MINUSC | |
MATCH | COINCIDIR | details |
MAX | MAX | |
MAXIFS | MAX.SI.CONJUNTO | |
MEDIAN | MEDIANA | |
MID | EXTRAE | details |
MIN | MIN | |
MINIFS | MIN.SI.CONJUNTO | |
MINUTE | MINUTO | |
MOD | RESIDUO | |
MODE | MODA | |
MONTH | MES | |
N | N | |
NA | NOD | |
NETWORKDAYS | DIAS.LAB | |
NOT | NO | |
NOW | AHORA | |
NPER | NPER | |
NPV | VNA | |
OFFSET | DESREF | |
OR | O | details |
PMT | PAGO | |
POWER | POTENCIA | |
PRODUCT | PRODUCTO | |
PROPER | NOMPROPIO | |
PV | VA | |
RAND | ALEATORIO | |
RANDBETWEEN | ALEATORIO.ENTRE | |
RANK | JERARQUIA | |
RATE | TASA | |
REPLACE | REEMPLAZAR | |
REPT | REPETIR | |
RIGHT | DERECHA | details |
ROUND | REDONDEAR | details |
ROUNDDOWN | REDONDEAR.MENOS | |
ROUNDUP | REDONDEAR.MAS | |
ROW | FILA | |
ROWS | FILAS | |
SEARCH | HALLAR | |
SECOND | SEGUNDO | |
SEQUENCE | SECUENCIA | |
SMALL | K.ESIMO.MENOR | |
SORT | ORDENAR | |
SORTBY | ORDENARPOR | |
SQRT | RAIZ | |
STDEV | DESVEST | |
SUBSTITUTE | SUSTITUIR | details |
SUBTOTAL | SUBTOTALES | |
SUM | SUMA | details |
SUMIF | SUMAR.SI | details |
SUMIFS | SUMAR.SI.CONJUNTO | details |
SUMPRODUCT | SUMAPRODUCTO | details |
SWITCH | CAMBIAR | |
TEXT | TEXTO | details |
TEXTJOIN | UNIRCADENAS | details |
TIME | NSHORA | |
TODAY | HOY | details |
TRANSPOSE | TRANSPONER | |
TRIM | ESPACIOS | details |
TRUE | VERDADERO | |
TYPE | TIPO | |
UNIQUE | UNICOS | |
UPPER | MAYUSC | |
VALUE | VALOR | |
VLOOKUP | BUSCARV | details |
VSTACK | APILARV | |
WEEKDAY | DIASEM | |
WORKDAY | DIA.LAB | |
XLOOKUP | BUSCARX | details |
XMATCH | COINCIDIRX | |
XOR | XO | |
YEAR | AÑO |