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