En
este articulo encontrará las equivalencias de la funciones de Excel de
español a ingles.
Español |
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 |
|
FALSO |
FALSE |
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 |
|
VERDADERO |
TRUE |
VF |
FV |
|
VNA |
NPV |
Y |
AND |
|
|
|
|
0 comentarios:
Publicar un comentario