Categories
Excel function translations Spanish to English
A list of all Excel function translations from Spanish to English. If you’re familiar with the Spanish version of Excel and you find yourself working with the English version, this list will be of use to you, because Excel functions have different names in different languages.
List of all Excel functions
translated from Spanish to English
Spanish | English |
ABS | ABS |
ACOS | ACOS |
ACOSH | ACOSH |
ACOT | ACOT |
ACOTH | ACOTH |
AGREGAR | AGGREGATE |
AHORA | NOW |
ALEATORIO | RAND |
ALEATORIO.ENTRE | RANDBETWEEN |
AMORTIZ.LIN | AMORLINC |
AMORTIZ.PROGRE | AMORDEGRC |
AÑO | YEAR |
AREAS | AREAS |
ASC | ASC |
ASENO | ASIN |
ASENOH | ASINH |
ATAN | ATAN |
ATAN2 | ATAN2 |
ATANH | ATANH |
BASE | BASE |
BDCONTAR | DCOUNT |
BDCONTARA | DCOUNTA |
BDDESVEST | DSTDEV |
BDDESVESTP | DSTDEVP |
BDEXTRAER | DGET |
BDMAX | DMAX |
BDMIN | DMIN |
BDPRODUCTO | DPRODUCT |
BDPROMEDIO | DAVERAGE |
BDSUMA | DSUM |
BDVAR | DVAR |
BDVARP | DVARP |
BESSELI | BESSELI |
BESSELJ | BESSELJ |
BESSELK | BESSELK |
BESSELY | BESSELY |
BIN.A.DEC | BIN2DEC |
BIN.A.HEX | BIN2HEX |
BIN.A.OCT | BIN2OCT |
BINOM.CRIT | CRITBINOM |
BIT.DESPLIZQDA | BITLSHIFT |
BIT.XO | BITXOR |
BIT.Y | BITAND |
BITOR | BITOR |
BITRSHIFT | BITRSHIFT |
BUSCAR | LOOKUP |
BUSCARH | HLOOKUP |
BUSCARV | VLOOKUP |
BUSCARX | XLOOKUP |
CANTIDAD.RECIBIDA | RECEIVED |
CARACTER | CHAR |
CEILING.MATH | CEILING.MATH |
CELDA | CELL |
COCIENTE | QUOTIENT |
CODIGO | CODE |
COEF.DE.CORREL | CORREL |
COEFICIENTE.ASIMETRIA | SKEW |
COEFICIENTE.ASIMETRIA.P | SKEW.P |
COEFICIENTE.R2 | RSQ |
COINCIDIR | MATCH |
COLUMNA | COLUMN |
COLUMNAS | COLUMNS |
COMBINA | COMBINA |
COMBINAT | COMBIN |
COMPLEJO | COMPLEX |
CONCATENAR | CONCATENATE |
CONJUNTOCUBO | CUBESET |
CONTAR | COUNT |
CONTAR.BLANCO | COUNTBLANK |
CONTAR.SI | COUNTIF |
CONTAR.SI.CONJUNTO | COUNTIFS |
CONTARA | COUNTA |
CONV.DECIMAL | DECIMAL |
CONV.DECIMAL | FIXED |
CONVERTIR | CONVERT |
COS | COS |
COSH | COSH |
COT | COT |
COTH | COTH |
COVAR | COVAR |
COVARIANZA.M | COVARIANCE.S |
COVARIANZA.P | COVARIANCE.P |
CRECIMIENTO | GROWTH |
CSC | CSC |
CSCH | CSCH |
CUARTIL | QUARTILE |
CUARTIL.EXC | QUARTILE.EXC |
CUARTIL.INC | QUARTILE.INC |
CUPON.DIAS | COUPDAYS |
CUPON.DIAS.L1 | COUPDAYBS |
CUPON.DIAS.L2 | COUPDAYSNC |
CUPON.FECHA.L1 | COUPPCD |
CUPON.FECHA.L2 | COUPNCD |
CUPON.NUM | COUPNUM |
CURTOSIS | KURT |
DB | DB |
DBCS | DBCS |
DDB | DDB |
DEC.A.BIN | DEC2BIN |
DEC.A.HEX | DEC2HEX |
DEC.A.OCT | DEC2OCT |
DELTA | DELTA |
DERECHA, DERECHAB | RIGHT, RIGHTB |
DESREF | OFFSET |
DESVEST | STDEV |
DESVEST.M | STDEV.S |
DESVEST.P | STDEV.P |
DESVESTA | STDEVA |
DESVESTP | STDEVP |
DESVESTPA | STDEVPA |
DESVIA2 | DEVSQ |
DESVPROM | AVEDEV |
DIA | DAY |
DIA.LAB | WORKDAY |
DIA.LAB.INTL | WORKDAY.INTL |
DIAS | DAYS |
DIAS.LAB | NETWORKDAYS |
DIAS.LAB.INTL | NETWORKDAYS.INTL |
DIAS360 | DAYS360 |
DIASEM | WEEKDAY |
DIRECCION | ADDRESS |
DIST.WEIBULL | WEIBULL |
DIST.WEIBULL | WEIBULL.DIST |
DISTR.BETA | BETA.DIST |
DISTR.BETA | BETADIST |
DISTR.BETA.INV | BETAINV |
DISTR.BINOM | BINOMDIST |
DISTR.BINOM.N | BINOM.DIST |
DISTR.BINOM.SERIE | BINOM.DIST.RANGE |
DISTR.CHI | CHIDIST |
DISTR.CHICUAD | CHISQ.DIST |
DISTR.CHICUAD.CD | CHISQ.DIST.RT |
DISTR.EXP | EXPONDIST |
DISTR.EXP.N | EXPON.DIST |
DISTR.F | FDIST |
DISTR.F.CD | F.DIST.RT |
DISTR.F.INV | FINV |
DISTR.F.RT | F.DIST |
DISTR.GAMMA | GAMMADIST |
DISTR.GAMMA.INV | GAMMAINV |
DISTR.GAMMA.N | GAMMA.DIST |
DISTR.HIPERGEOM | HYPGEOMDIST |
DISTR.HIPERGEOM.N | HYPGEOM.DIST |
DISTR.LOG.INV | LOGINV |
DISTR.LOG.NORM | LOGNORMDIST |
DISTR.LOGNORM | LOGNORM.DIST |
DISTR.NORM | NORMDIST |
DISTR.NORM.ESTAND | NORMSDIST |
DISTR.NORM.ESTAND.INV | NORMSINV |
DISTR.NORM.ESTAND.N | NORM.S.DIST |
DISTR.NORM.INV | NORMINV |
DISTR.NORM.N | NORM.DIST |
DISTR.T | TDIST |
DISTR.T.2C | T.DIST.2T |
DISTR.T.CD | T.DIST.RT |
DISTR.T.INV | TINV |
DISTR.T.N | T.DIST |
DURACION | DURATION |
DURACION.MODIF | MDURATION |
DVS | VDB |
ELEGIR | CHOOSE |
ENCONTRAR, ENCONTRARB | FIND, FINDB |
ENTERO | INT |
ERROR.TIPICO.XY | STEYX |
ES.IMPAR | ISODD |
ES.PAR | ISEVEN |
ESBLANCO | ISBLANK |
ESERR | ISERR |
ESERROR | ISERROR |
ESFORMULA | ISFORMULA |
ESLOGICO | ISLOGICAL |
ESNOD | ISNA |
ESNOTEXTO | ISNONTEXT |
ESNUMERO | ISNUMBER |
ESPACIOS | TRIM |
ESREF | ISREF |
ESTEXTO | ISTEXT |
ESTIMACION.LINEAL | LINEST |
ESTIMACION.LOGARITMICA | LOGEST |
EUROCONVERT | EUROCONVERT |
EXP | EXP |
EXTRAE, EXTRAEB | MID, MIDB |
FACT | FACT |
FACT.DOBLE | FACTDOUBLE |
FALSO | FALSE |
FECHA | DATE |
FECHA.MES | EDATE |
FECHANUMERO | DATEVALUE |
FI | PHI |
FILA | ROW |
FILAS | ROWS |
FIN.MES | EOMONTH |
FISHER | FISHER |
FONETICO | PHONETIC |
FORMULATEXT | FORMULATEXT |
FRAC.AÑO | YEARFRAC |
FRECUENCIA | FREQUENCY |
FUN.ERROR | ERF |
FUN.ERROR.COMPL | ERFC |
FUN.ERROR.COMPL.EXACTO | ERFC.PRECISE |
FUN.ERROR.EXACTO | ERF.PRECISE |
GAMMA | GAMMA |
GAMMA.LN | GAMMALN |
GAMMA.LN.EXACTO | GAMMALN.PRECISE |
GAUSS | GAUSS |
GRADOS | DEGREES |
HALLAR, HALLARB | SEARCH, SEARCHB |
HEX.A.BIN | HEX2BIN |
HEX.A.DEC | HEX2DEC |
HEX.A.OCT | HEX2OCT |
HIPERVINCULO | HYPERLINK |
HOJA | SHEET |
HOJAS | SHEETS |
HORA | HOUR |
HORANUMERO | TIMEVALUE |
HOY | TODAY |
ID.REGISTRO | REGISTER.ID |
IGUAL | EXACT |
IM.ABS | IMABS |
IM.ANGULO | IMARGUMENT |
IM.CONJUGADA | IMCONJUGATE |
IM.COS | IMCOS |
IM.COSH | IMCOSH |
IM.CSC | IMCSC |
IM.CSCH | IMCSCH |
IM.DIV | IMDIV |
IM.EXP | IMEXP |
IM.LN | IMLN |
IM.LOG10 | IMLOG10 |
IM.LOG2 | IMLOG2 |
IM.POT | IMPOWER |
IM.PRODUCT | IMPRODUCT |
IM.RAIZ2 | IMSQRT |
IM.REAL | IMREAL |
IM.SEC | IMSEC |
IM.SECH | IMSECH |
IM.SENO | IMSIN |
IM.SENOH | IMSINH |
IM.SUM | IMSUM |
IM.SUSTR | IMSUB |
IM.TAN | IMTAN |
IMAGINARIO | IMAGINARY |
IMCOT | IMCOT |
IMPORTARDATOSDINAMICOS | GETPIVOTDATA |
INDICE | INDEX |
INDIRECTO | INDIRECT |
INFO | INFO |
INT.ACUM | ACCRINT |
INT.ACUM.V | ACCRINTM |
INT.EFECTIVO | EFFECT |
INT.PAGO.DIR | ISPMT |
INTERSECCION.EJE | INTERCEPT |
INTERVALO.CONFIANZA | CONFIDENCE |
INTERVALO.CONFIANZA.NORM | CONFIDENCE.NORM |
INTERVALO.CONFIANZA.T | CONFIDENCE.T |
INV.BETA | BETA.INV |
INV.BINOM | BINOM.INV |
INV.CHICUAD | CHISQ.INV |
INV.CHICUAD.CD | CHISQ.INV.RT |
INV.F | F.INV |
INV.F.CD | F.INV.RT |
INV.GAMMA | GAMMA.INV |
INV.LOGNORM | LOGNORM.INV |
INV.NORM | NORM.INV |
INV.NORM.ESTAND | NORM.S.INV |
INV.T | T.INV |
INV.T.2C | T.INV.2T |
ISO.NUM.DE.SEMANA | ISOWEEKNUM |
IZQUIERDA, IZQUIERDAB | LEFT, LEFTB |
JERARQUIA | RANK |
JERARQUIA.EQV | RANK.EQ |
JERARQUIA.MEDIA | RANK.AVG |
K.ESIMO.MAYOR | LARGE |
K.ESIMO.MENOR | SMALL |
LARGO, LARGOB | LEN, LENB |
LETRA.DE.TES.EQV.A.BONO | TBILLEQ |
LETRA.DE.TES.PRECIO | TBILLPRICE |
LETRA.DE.TES.RENDTO | TBILLYIELD |
LIMPIAR | CLEAN |
LLAMAR | CALL |
LN | LN |
LOG | LOG |
LOG10 | LOG10 |
M.C.D | GCD |
M.C.M | LCM |
MAX | MAX |
MAXA | MAXA |
MAYOR.O.IGUAL | GESTEP |
MAYUSC | UPPER |
MDETERM | MDETERM |
MEDIA.ACOTADA | TRIMMEAN |
MEDIA.ARMO | HARMEAN |
MEDIA.GEOM | GEOMEAN |
MEDIANA | MEDIAN |
MES | MONTH |
MIEMBROCUBO | CUBEMEMBER |
MIEMBROKPICUBO | CUBEKPIMEMBER |
MIEMBRORANGOCUBO | CUBERANKEDMEMBER |
MIN | MIN |
MINA | MINA |
MINUSC | LOWER |
MINUTO | MINUTE |
MINVERSA | MINVERSE |
MMULT | MMULT |
MODA | MODE |
MODA.UNO | MODE.SNGL |
MODA.VARIOS | MODE.MULT |
MONEDA | DOLLAR |
MONEDA.DEC | DOLLARDE |
MONEDA.FRAC | DOLLARFR |
MULTINOMIAL | MULTINOMIAL |
MULTIPLO.INFERIOR | FLOOR |
MULTIPLO.INFERIOR.EXACTO | FLOOR.PRECISE |
MULTIPLO.INFERIOR.MAT | FLOOR.MATH |
MULTIPLO.SUPERIOR | CEILING |
MULTIPLO.SUPERIOR.EXACTO | CEILING.PRECISE |
MULTIPLO.SUPERIOR.ISO | ISO.CEILING |
MUNIT | MUNIT |
N | N |
NEGBINOM.DIST | NEGBINOM.DIST |
NEGBINOMDIST | NEGBINOMDIST |
NO | NOT |
NOD | NA |
NOMPROPIO | PROPER |
NORMALIZACION | STANDARDIZE |
NPER | NPER |
NUM.DE.SEMANA | WEEKNUM |
NUMERO.ARABE | ARABIC |
NUMERO.ROMANO | ROMAN |
O | OR |
OCT.A.BIN | OCT2BIN |
OCT.A.DEC | OCT2DEC |
OCT.A.HEX | OCT2HEX |
P.DURACION | PDURATION |
PAGO | PMT |
PAGO.INT.ENTRE | CUMIPMT |
PAGO.PRINC.ENTRE | CUMPRINC |
PAGOINT | IPMT |
PAGOPRIN | PPMT |
PEARSON | PEARSON |
PENDIENTE | SLOPE |
PERCENTIL | PERCENTILE |
PERCENTIL.EXC | PERCENTILE.EXC |
PERCENTIL.INC | PERCENTILE.INC |
PERMUTACIONES | PERMUT |
PERMUTACIONES.A | PERMUTATIONA |
PI | PI |
POISSON | POISSON |
POISSON.DIST | POISSON.DIST |
POTENCIA | POWER |
PRECIO | PRICE |
PRECIO.DESCUENTO | PRICEDISC |
PRECIO.PER.IRREGULAR.1 | ODDFPRICE |
PRECIO.PER.IRREGULAR.2 | ODDLPRICE |
PRECIO.VENCIMIENTO | PRICEMAT |
PROBABILIDAD | PROB |
PRODUCTO | PRODUCT |
PROMEDIO | AVERAGE |
PROMEDIO.SI | AVERAGEIF |
PROMEDIO.SI.CONJUNTO | AVERAGEIFS |
PROMEDIOA | AVERAGEA |
PRONOSTICO | FORECAST |
PROPIEDADMIEMBROCUBO | CUBEMEMBERPROPERTY |
PRUEBA.CHI | CHITEST |
PRUEBA.CHI.INV | CHIINV |
PRUEBA.CHICUAD | CHISQ.TEST |
PRUEBA.F | FTEST |
PRUEBA.F.N | F.TEST |
PRUEBA.FISHER.INV | FISHERINV |
PRUEBA.T | T.TEST |
PRUEBA.T | TTEST |
PRUEBA.Z | Z.TEST |
PRUEBA.Z | ZTEST |
RADIANES | RADIANS |
RAIZ | SQRT |
RAIZ2PI | SQRTPI |
RANGO.PERCENTIL | PERCENTRANK |
RANGO.PERCENTIL.EXC | PERCENTRANK.EXC |
RANGO.PERCENTIL.INC | PERCENTRANK.INC |
RDTR | RTD |
RECUENTOCONJUNTOCUBO | CUBESETCOUNT |
REDOND.MULT | MROUND |
REDONDEA.IMPAR | ODD |
REDONDEA.PAR | EVEN |
REDONDEAR | ROUND |
REDONDEAR.MAS | ROUNDUP |
REDONDEAR.MENOS | ROUNDDOWN |
REEMPLAZAR, REEMPLAZARB | REPLACE, REPLACEB |
RENDTO | YIELD |
RENDTO.DESC | YIELDDISC |
RENDTO.PER.IRREGULAR.1 | ODDFYIELD |
RENDTO.PER.IRREGULAR.2 | ODDLYIELD |
RENDTO.VENCTO | YIELDMAT |
REPETIR | REPT |
RESIDUO | MOD |
RRI | RRI |
SEC | SEC |
SECH | SECH |
SEGUNDO | SECOND |
SENO | SIN |
SENOH | SINH |
SERVICIOWEB | WEBSERVICE |
SI | IF |
SI.ERROR | IFERROR |
SI.ND | IFNA |
SIGNO | SIGN |
SLN | SLN |
SQL.REQUEST | SQL.REQUEST |
SUBTOTALES | SUBTOTAL |
SUMA | SUM |
SUMA.CUADRADOS | SUMSQ |
SUMA.SERIES | SERIESSUM |
SUMAPRODUCTO | SUMPRODUCT |
SUMAR.SI | SUMIF |
SUMAR.SI.CONJUNTO | SUMIFS |
SUMAX2MASY2 | SUMX2PY2 |
SUMAX2MENOSY2 | SUMX2MY2 |
SUMAXMENOSY2 | SUMXMY2 |
SUSTITUIR | SUBSTITUTE |
SYD | SYD |
T | T |
TAN | TAN |
TANH | TANH |
TASA | RATE |
TASA.DESC | DISC |
TASA.INT | INTRATE |
TASA.NOMINAL | NOMINAL |
TENDENCIA | TREND |
TEXTO | TEXT |
TEXTOBAHT | BAHTTEXT |
TIEMPO | TIME |
TIPO | TYPE |
TIPO.DE.ERROR | ERROR.TYPE |
TIR | IRR |
TIR.NO.PER | XIRR |
TIRM | MIRR |
TRANSPONER | TRANSPOSE |
TRUNCAR | TRUNC |
UNICAR | UNICHAR |
UNICODE | UNICODE |
URLCODIF | ENCODEURL |
VA | PV |
VALOR | VALUE |
VALOR.NUMERO | NUMBERVALUE |
VALORCUBO | CUBEVALUE |
VAR | VAR |
VAR.P | VAR.P |
VAR.S | VAR.S |
VARA | VARA |
VARP | VARP |
VARPA | VARPA |
VERDADERO | TRUE |
VF | FV |
VF.PLAN | FVSCHEDULE |
VNA | NPV |
VNA.NO.PER | XNPV |
XMLFILTRO | FILTERXML |
XO | XOR |
Y | AND |