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