Conversion of Excel formulas: English - Spanish equivalences
Below you will find the name of Excel formulas in English and their equivalence
in Spanish.
|
|
English |
Spanish |
|
|
ABS |
ABS |
|
|
ACOS |
ACOS |
|
|
ACOSH |
ACOSH |
|
|
NOW |
AHORA |
|
|
RAND |
ALEATORIO |
|
|
AREAS |
AREAS |
|
|
ASIN |
ASENO |
|
|
ASINH |
ASENOH |
|
|
ATAN |
ATAN |
|
|
ATAN2 |
ATAN2 |
|
|
ATANH |
ATANH |
|
|
YEAR |
AÑO |
|
|
DCOUNT |
BDCONTAR |
|
|
DCOUNTA |
BDCONTARA |
|
|
DSTDEV |
BDDESVEST |
|
|
DSTDEVP |
BDDESVESTP |
|
|
DGET |
BDEXTRAER |
|
|
DMAX |
BDMAX |
|
|
DMIN |
BDMIN |
|
|
DPRODUCT |
BDPRODUCTO |
|
|
DAVERAGE |
BDPROMEDIO |
|
|
DSUM |
BDSUMA |
|
|
DVAR |
BDVAR |
|
|
DVARP |
BDVARP |
|
|
CRITBINOM |
BINOM.CRIT |
|
|
LOOKUP |
BUSCAR |
|
|
HLOOKUP |
BUSCARH |
|
|
VLOOKUP |
BUSCARV |
|
|
CHAR |
CARACTER |
|
|
CELL |
CELDA |
|
|
CODE |
CODIGO |
|
|
CORREL |
COEF.DE.CORREL |
|
|
SKEW |
COEFICIENTE.ASIMETRIA |
|
|
RSQ |
COEFICIENTE.R2 |
|
|
MATCH |
COINCIDIR |
|
|
COLUMN |
COLUMNA |
|
|
COLUMNS |
COLUMNAS |
|
|
COMBIN |
COMBINAT |
|
|
CONCATENATE |
CONCATENAR |
|
|
COUNT |
CONTAR |
|
|
COUNTBLANK |
CONTAR.BLANCO |
|
|
COUNTIF |
CONTAR.SI |
|
|
COUNTA |
CONTARA |
|
|
COS |
COS |
|
|
COSH |
COSH |
|
|
COVAR |
COVAR |
|
|
GROWTH |
CRECIMIENTO |
|
|
QUARTILE |
CUARTIL |
|
|
KURT |
CURTOSIS |
|
|
DB |
DB |
|
|
DDB |
DDB |
|
|
FIXED |
DECIMAL |
|
|
RIGHT |
DERECHA |
|
|
OFFSET |
DESREF |
|
|
STDEV |
DESVEST |
|
|
STDEVP |
DESVESTP |
|
|
DEVSQ |
DESVIA2 |
|
|
AVEDEV |
DESVPROM |
|
|
DAY |
DIA |
|
|
DAYS360 |
DIAS360 |
|
|
WEEKDAY |
DIASEM |
|
|
ADDRESS |
DIRECCION |
|
|
WEIBULL |
DIST.WEIBULL |
|
|
BETADIST |
DISTR.BETA |
|
|
BETAINV |
DISTR.BETA.INV |
|
|
BINOMDIST |
DISTR.BINOM |
|
|
CHIDIST |
DISTR.CHI |
|
|
EXPONDIST |
DISTR.EXP |
|
|
FDIST |
DISTR.F |
|
|
FINV |
DISTR.F.INV |
|
|
GAMMADIST |
DISTR.GAMMA |
|
|
GAMMAINV |
DISTR.GAMMA.INV |
|
|
HYPGEOMDIST |
DISTR.HIPERGEOM |
|
|
LOGINV |
DISTR.LOG.INV |
|
|
LOGNORMDIST |
DISTR.LOG.NORM |
|
|
NORMDIST |
DISTR.NORM |
|
|
NORMSDIST |
DISTR.NORM.ESTAND |
|
|
NORMSINV |
DISTR.NORM.ESTAND.INV |
|
|
NORMINV |
DISTR.NORM.INV |
|
|
TDIST |
DISTR.T |
|
|
TINV |
DISTR.T.INV |
|
|
VDB |
DVS |
|
|
CHOOSE |
ELEGIR |
|
|
FIND |
ENCONTRAR |
|
|
INT |
ENTERO |
|
|
STEYX |
ERROR.TIPICO.XY |
|
|
ISBLANK |
ESBLANCO |
|
|
ISERR |
ESERR |
|
|
ISERROR |
ESERROR |
|
|
ISLOGICAL |
ESLOGICO |
|
|
ISNA |
ESNOD |
|
|
ISNONTEXT |
ESNOTEXTO |
|
|
ISNUMBER |
ESNUMERO |
|
|
TRIM |
ESPACIOS |
|
|
ISREF |
ESREF |
|
|
ISTEXT |
ESTEXTO |
|
|
LINEST |
ESTIMACION.LINEAL |
|
|
LOGEST |
ESTIMACION.LOGARITMICA |
|
|
EXP |
EXP |
|
|
MID |
EXTRAE |
|
|
FACT |
FACT |
|
|
DATE |
FECHA |
|
|
DATEVALUE |
FECHANUMERO |
|
|
ROW |
FILA |
|
|
ROWS |
FILAS |
|
|
FISHER |
FISHER |
|
|
FREQUENCY |
FRECUENCIA |
|
|
GAMMALN |
GAMMA.LN |
|
|
DEGREES |
GRADOS |
|
|
SEARCH |
HALLAR |
|
|
HOUR |
HORA |
|
|
TIMEVALUE |
HORANUMERO |
|
|
TODAY |
HOY |
|
|
REGISTER.ID |
ID.REGISTRO |
|
|
EXACT |
IGUAL |
|
|
INDEX |
INDICE |
|
|
INDIRECT |
INDIRECTO |
|
|
INFO |
INFO |
|
|
INTERCEPT |
INTERSECCION |
|
|
CONFIDENCE |
INTERVALO.CONFIANZA |
|
|
LEFT |
IZQUIERDA |
|
|
RANK |
JERARQUIA |
|
|
LARGE |
K.ESIMO.MAYOR |
|
|
SMALL |
K.ESIMO.MENOR |
|
|
LEN |
LARGO |
|
|
CLEAN |
LIMPIAR |
|
|
CALL |
LLAMAR |
|
|
LN |
LN |
|
|
LOG |
LOG |
|
|
LOG10 |
LOG10 |
|
|
MAX |
MAX |
|
|
UPPER |
MAYUSC |
|
|
MDETERM |
MDETERM |
|
|
TRIMMEAN |
MEDIA.ACOTADA |
|
|
HARMEAN |
MEDIA.ARMO |
|
|
GEOMEAN |
MEDIA.GEOM |
|
|
MEDIAN |
MEDIANA |
|
|
MONTH |
MES |
|
|
MIN |
MIN |
|
|
LOWER |
MINUSC |
|
|
MINUTE |
MINUTO |
|
|
MINVERSE |
MINVERSA |
|
|
MMULT |
MMULT |
|
|
MODE |
MODA |
|
|
DOLLAR |
MONEDA |
|
|
FLOOR |
MULTIPLO.INFERIOR |
|
|
CEILING |
MULTIPLO.SUPERIOR |
|
|
N |
N |
|
|
NEGBINOMDIST |
NEGBINOMDIST |
|
|
NOT |
NO |
|
|
NA |
NOD |
|
|
PROPER |
NOMPROPIO |
|
|
STANDARDIZE |
NORMALIZACION |
|
|
NPER |
NPER |
|
|
TIME |
NSHORA |
|
|
ROMAN |
NUMERO.ROMANO |
|
|
OR |
O |
|
|
PMT |
PAGO |
|
|
IPMT |
PAGOINT |
|
|
PPMT |
PAGOPRIN |
|
|
PEARSON |
PEARSON |
|
|
SLOPE |
PENDIENTE |
|
|
PERCENTILE |
PERCENTIL |
|
|
PERMUT |
PERMUTACIONES |
|
|
PI |
PI |
|
|
POISSON |
POISSON |
|
|
POWER |
POTENCIA |
|
|
PROB |
PROBABILIDAD |
|
|
PRODUCT |
PRODUCTO |
|
|
AVERAGE |
PROMEDIO |
|
|
FORECAST |
PRONOSTICO |
|
|
CHITEST |
PRUEBA.CHI |
|
|
CHIINV |
PRUEBA.CHI.INV |
|
|
FTEST |
PRUEBA.F |
|
|
FISHERINV |
PRUEBA.FISHER.INV |
|
|
TTEST |
PRUEBA.T |
|
|
ZTEST |
PRUEBA.Z |
|
|
RADIANS |
RADIANES |
|
|
SQRT |
RAIZ |
|
|
PERCENTRANK |
RANGO.PERCENTIL |
|
|
ODD |
REDONDEA.IMPAR |
|
|
EVEN |
REDONDEA.PAR |
|
|
ROUND |
REDONDEAR |
|
|
ROUNDUP |
REDONDEAR.MAS |
|
|
ROUNDDOWN |
REDONDEAR.MENOS |
|
|
REPLACE |
REEMPLAZAR |
|
|
REPT |
REPETIR |
|
|
MOD |
RESIDUO |
|
|
SECOND |
SEGUNDO |
|
|
SIN |
SENO |
|
|
SINH |
SENOH |
|
|
IF |
SI |
|
|
SIGN |
SIGNO |
|
|
SLN |
SLN |
|
|
SUBTOTAL |
SUBTOTALES |
|
|
SUM |
SUMA |
|
|
SUMSQ |
SUMA.CUADRADOS |
|
|
SUMPRODUCT |
SUMAPRODUCTO |
|
|
SUMIF |
SUMAR.SI |
|
|
SUMX2PY2 |
SUMAX2MASY2 |
|
|
SUMX2MY2 |
SUMAX2MENOSY2 |
|
|
SUMXMY2 |
SUMAXMENOSY2 |
|
|
SUBSTITUTE |
SUSTITUIR |
|
|
SYD |
SYD |
|
|
T |
T |
|
|
TAN |
TAN |
|
|
TANH |
TANH |
|
|
RATE |
TASA |
|
|
TREND |
TENDENCIA |
|
|
TEXT |
TEXTO |
|
|
TYPE |
TIPO |
|
|
ERROR.TYPE |
TIPO.DE.ERROR |
|
|
IRR |
TIR |
|
|
MIRR |
TIRM |
|
|
TRANSPOSE |
TRANSPONER |
|
|
TRUNC |
TRUNCAR |
|
|
PV |
VA |
|
|
VALUE |
VALOR |
|
|
VAR |
VAR |
|
|
VARP |
VARP |
|
|
FV |
VF |
|
|
NPV |
VNA |
|
|
AND |
Y |
|
|
FALSE |
FALSO |
|
|
TRUE |
VERDADERO |
If you need further information about optimization services related to these formulas,
please contact us.
