Traducción de fórmulas Excel en español a inglés
Cuando trabajas con Microsoft Excel poco a poco comienzas a aprender una serie de formulas que se vuelven parte de ti de tu manera de trabajar comienzas a formular sin ni siquiera pensarlo o analizarlo solo comienzas a escribe en código para otras personas que se maravillan de las cosas que tu puedes hacer con un par de línea de código o en mi caso para mi es un leguaje. Que pasaría su un día no estas en tu computadoras y te tocas un trabajo urgente pero adivina que el Office de la computadora que tienes estas en Ingles, Dios es como que te cambiaran las reglas del juego te sientes inútil lo digo por experiencia ya que esto me paso
Por eso encontré esta solución y se las comparto
| # | Español | Inglés |
| 1 | ABRIR.ARCHIVO | OPEN.DIALOG |
| 2 | ABRIRA | FOPEN |
| 3 | ABS | ABS |
| 4 | ACOS | ACOS |
| 5 | ACOSH | ACOSH |
| 6 | AGREGAR.BARRA | ADD.BAR |
| 7 | AGREGAR.BARRA.HERRAMIENTAS | ADD.TOOLBAR |
| 8 | AGREGAR.COMANDO | ADD.COMMAND |
| 9 | AGREGAR.MENU | ADD.MENU |
| 10 | AGRUPAR | GROUP |
| 11 | AHORA | NOW |
| 12 | ALEATORIO | RAND |
| 13 | AÑO | YEAR |
| 14 | APL.TITULO | APP.TITLE |
| 15 | ARCHIVOS | FILES |
| 16 | AREAS | AREAS |
| 17 | ARGUMENTO | ARGUMENT |
| 18 | ASC | ASC |
| 19 | ASENO | ASIN |
| 20 | ASENOH | ASINH |
| 21 | ATAN | ATAN |
| 22 | ATAN2 | ATAN2 |
| 23 | ATANH | ATANH |
| 24 | AYUDA | HELP |
| 25 | BDCONTAR | DCOUNT |
| 26 | BDCONTARA | DCOUNTA |
| 27 | BDDESVEST | DSTDEV |
| 28 | BDDESVESTP | DSTDEVP |
| 29 | BDEXTRAER | DGET |
| 30 | BDMAX | DMAX |
| 31 | BDMIN | DMIN |
| 32 | BDPRODUCTO | DPRODUCT |
| 33 | BDPROMEDIO | DAVERAGE |
| 34 | BDSUMA | DSUM |
| 35 | BDVAR | DVAR |
| 36 | BDVARP | DVARP |
| 37 | BINOM.CRIT | CRITBINOM |
| 38 | BUSCAR | LOOKUP |
| 39 | BUSCARH | HLOOKUP |
| 40 | BUSCARV | VLOOKUP |
| 41 | CADENA.FECHA | DATESTRING |
| 42 | CADENA.NUMERO | NUMBERSTRING |
| 43 | CAMBIAR.NOMBRE.COMANDO | RENAME.COMMAND |
| 44 | CANCELAR.TECLA | CANCEL.KEY |
| 45 | CARACTER | CHAR |
| 46 | CELDA | CELL |
| 47 | CELDA.ACTIVA | ACTIVE.CELL |
| 48 | CERRARA | FCLOSE |
| 49 | CODIGO | CODE |
| 50 | COEF.DE.CORREL | CORREL |
| 51 | COEFICIENTE.ASIMETRIA | SKEW |
| 52 | COEFICIENTE.R2 | RSQ |
| 53 | COINCIDIR | MATCH |
| 54 | COLUMNA | COLUMN |
| 55 | COLUMNAS | COLUMNS |
| 56 | COMBINAT | COMBIN |
| 57 | CONCATENAR | CONCATENATE |
| 58 | CONTAR | COUNT |
| 59 | CONTAR.BLANCO | COUNTBLANK |
| 60 | CONTAR.SI | COUNTIF |
| 61 | CONTARA | COUNTA |
| 62 | COS | COS |
| 63 | COSH | COSH |
| 64 | COVAR | COVAR |
| 65 | CREAR.OBJETO | CREATE.OBJECT |
| 66 | CRECIMIENTO | GROWTH |
| 67 | CUADRO.DE.DIALOGO | DIALOG.BOX |
| 68 | CUADRO.DE.TEXTO | TEXT.BOX |
| 69 | CUARTIL | QUARTILE |
| 70 | CURTOSIS | KURT |
| 71 | DB | DB |
| 72 | DBCS | DBCS |
| 73 | DDB | DDB |
| 74 | DECIMAL | FIXED |
| 75 | DERECHA | RIGHT |
| 76 | DERECHAB | RIGHTB |
| 77 | DESREF | OFFSET |
| 78 | DESREGISTRAR | UNREGISTER |
| 79 | DESVEST | STDEV |
| 80 | DESVESTP | STDEVP |
| 81 | DESVIA2 | DEVSQ |
| 82 | DESVPROM | AVEDEV |
| 83 | DETENER | HALT |
| 84 | DIA | DAY |
| 85 | DIAS360 | DAYS360 |
| 86 | DIASEM | WEEKDAY |
| 87 | DIRECCION | ADDRESS |
| 88 | DIRECTORIO | DIRECTORY |
| 89 | DIST.WEIBULL | WEIBULL |
| 90 | DISTR.BETA | BETADIST |
| 91 | DISTR.BETA.INV | BETAINV |
| 92 | DISTR.BINOM | BINOMDIST |
| 93 | DISTR.CHI | CHIDIST |
| 94 | DISTR.EXP | EXPONDIST |
| 95 | DISTR.F | FDIST |
| 96 | DISTR.F.INV | FINV |
| 97 | DISTR.GAMMA | GAMMADIST |
| 98 | DISTR.GAMMA.INV | GAMMAINV |
| 99 | DISTR.HIPERGEOM | HYPGEOMDIST |
| 100 | DISTR.LOG.INV | LOGINV |
| 101 | DISTR.LOG.NORM | LOGNORMDIST |
| 102 | DISTR.NORM | NORMDIST |
| 103 | DISTR.NORM.ESTAND | NORMSDIST |
| 104 | DISTR.NORM.ESTAND.INV | NORMSINV |
| 105 | DISTR.NORM.INV | NORMINV |
| 106 | DISTR.T | TDIST |
| 107 | DISTR.T.INV | TINV |
| 108 | DOCUMENTOS | DOCUMENTS |
| 109 | DVS | VDB |
| 110 | ECHO | ECHO |
| 111 | EJEC | EXEC |
| 112 | EJECUTA | EXECUTE |
| 113 | ELEGIR | CHOOSE |
| 114 | ELIMINAR.BARRA | DELETE.BAR |
| 115 | ELIMINAR.BARRA.HERRAMIENTAS | DELETE.TOOLBAR |
| 116 | ELIMINAR.COMANDO | DELETE.COMMAND |
| 117 | ELIMINAR.MENU | DELETE.MENU |
| 118 | ENCONTRAR | FIND |
| 119 | ENCONTRARB | FINDB |
| 120 | ENTERO | INT |
| 121 | ERROR | ERROR |
| 122 | ERROR.TIPICO.XY | STEYX |
| 123 | ESBLANCO | ISBLANK |
| 124 | ESCENARIO.INDICAR | SCENARIO.GET |
| 125 | ESCRIBIRA | FWRITE |
| 126 | ESCRIBIRALN | FWRITELN |
| 127 | ESERR | ISERR |
| 128 | ESERROR | ISERROR |
| 129 | ESLOGICO | ISLOGICAL |
| 130 | ESNOD | ISNA |
| 131 | ESNOTEXTO | ISNONTEXT |
| 132 | ESNUMERO | ISNUMBER |
| 133 | ESPACIOS | TRIM |
| 134 | ESREF | ISREF |
| 135 | ESTABLECER.NOMBRE | SET.NAME |
| 136 | ESTABLECER.VALOR | SET.VALUE |
| 137 | ESTEXTO | ISTEXT |
| 138 | ESTIMACION.LINEAL | LINEST |
| 139 | ESTIMACION.LOGARITMICA | LOGEST |
| 140 | EVALUAR | EVALUATE |
| 141 | EXP | EXP |
| 142 | EXTRAE | MIDB |
| 143 | EXTRAE | MID |
| 144 | FACT | FACT |
| 145 | FECHA | DATE |
| 146 | FECHANUMERO | DATEVALUE |
| 147 | FILA | ROW |
| 148 | FILAS | ROWS |
| 149 | FISHER | FISHER |
| 150 | FORMULA.CONVERTIR | FORMULA.CONVERT |
| 151 | FRECUENCIA | FREQUENCY |
| 152 | GAMMA.LN | GAMMALN |
| 153 | GET.MOVIE | GET.MOVIE |
| 154 | GRADOS | DEGREES |
| 155 | GUARDAR.ARCHIVO | SAVE.DIALOG |
| 156 | GUARDAR.BARRA.HERRAMIENTAS | SAVE.TOOLBAR |
| 157 | HABILITAR.COMANDO | ENABLE.COMMAND |
| 158 | HABILITAR.HERRAMIENTA | ENABLE.TOOL |
| 159 | HALLAR | SEARCH |
| 160 | HALLARB | SEARCHB |
| 161 | HORA | HOUR |
| 162 | HORANUMERO | TIMEVALUE |
| 163 | HOY | TODAY |
| 164 | ID.REGISTRO | REGISTER.ID |
| 165 | IGUAL | EXACT |
| 166 | INDICAR.AREA.DE.TRABAJO | GET.WORKSPACE |
| 167 | INDICAR.BARRA | GET.BAR |
| 168 | INDICAR.BARRA.HERRAMIENTAS | GET.TOOLBAR |
| 169 | INDICAR.CAMPO.TABLA.DI | GET.PIVOT.FIELD |
| 170 | INDICAR.CELDA | GET.CELL |
| 171 | INDICAR.DEF | GET.DEF |
| 172 | INDICAR.DOCUMENTO | GET.DOCUMENT |
| 173 | INDICAR.ELEMENTO.GRAFICO | GET.CHART.ITEM |
| 174 | INDICAR.ELEMENTO.TABLA.DI | GET.PIVOT.ITEM |
| 175 | INDICAR.FORMULA | GET.FORMULA |
| 176 | INDICAR.HERRAMIENTA | GET.TOOL |
| 177 | INDICAR.INFO.VINCULO | GET.LINK.INFO |
| 178 | INDICAR.LIBRO | GET.WORKBOOK |
| 179 | INDICAR.NOMBRE | GET.NAME |
| 180 | INDICAR.NOTAS | GET.NOTE |
| 181 | INDICAR.OBJETO | GET.OBJECT |
| 182 | INDICAR.TABLA.DINAMICA | GET.PIVOT.TABLE |
| 183 | INDICAR.VENTANA | GET.WINDOW |
| 184 | INDICE | INDEX |
| 185 | INDIRECTO | INDIRECT |
| 186 | INFO | INFO |
| 187 | INICIAR | INITIATE |
| 188 | INT.PAGO.DIR | ISPMT |
| 189 | INTERSECCION | INTERCEPT |
| 190 | INTERVALO.CONFIANZA | CONFIDENCE |
| 191 | INTRODUCIR | INPUT |
| 192 | IR.A | GOTO |
| 193 | IZQUIERDA | LEFT |
| 194 | IZQUIERDAB | LEFTB |
| 195 | JERARQUIA | RANK |
| 196 | K.ESIMO.MAYOR | LARGE |
| 197 | K.ESIMO.MENOR | SMALL |
| 198 | LARGO | LEN |
| 199 | LARGOB | LENB |
| 200 | LEERA | FREAD |
| 201 | LEERALN | FREADLN |
| 202 | LIMPIAR | CLEAN |
| 203 | LN | LN |
| 204 | LOG | LOG |
| 205 | LOG10 | LOG10 |
| 206 | LLAMADOR | CALLER |
| 207 | LLAMAR | CALL |
| 208 | MARCAR.COMANDO | CHECK.COMMAND |
| 209 | MAX | MAX |
| 210 | MAYUSC | UPPER |
| 211 | MDETERM | MDETERM |
| 212 | MEDIA.ACOTADA | TRIMMEAN |
| 213 | MEDIA.ARMO | HARMEAN |
| 214 | MEDIA.GEOM | GEOMEAN |
| 215 | MEDIANA | MEDIAN |
| 216 | MES | MONTH |
| 217 | MIN | MIN |
| 218 | MINUSC | LOWER |
| 219 | MINUTO | MINUTE |
| 220 | MINVERSA | MINVERSE |
| 221 | MMULT | MMULT |
| 222 | MODA | MODE |
| 223 | MONEDA | DOLLAR |
| 224 | MOSTRAR.BARRA | SHOW.BAR |
| 225 | MOVIE.COMMAND | MOVIE.COMMAND |
| 226 | MULTIPLO.INFERIOR | FLOOR |
| 227 | MULTIPLO.SUPERIOR | CEILING |
| 228 | N | N |
| 229 | NEGBINOMDIST | NEGBINOMDIST |
| 230 | NO | NOT |
| 231 | NOD | NA |
| 232 | NOMBRES | NAMES |
| 233 | NOMPROPIO | PROPER |
| 234 | NORMALIZACION | STANDARDIZE |
| 235 | NOTA | NOTE |
| 236 | NPER | NPER |
| 237 | NSHORA | TIME |
| 238 | NUMERO.ROMANO | ROMAN |
| 239 | O | OR |
| 240 | OPCIONES.INDICAR.LISTAS | OPTIONS.LISTS.GET |
| 241 | PAGO | PMT |
| 242 | PAGOINT | IPMT |
| 243 | PAGOPRIN | PPMT |
| 244 | PASO.A.PASO | STEP |
| 245 | PAUSA | PAUSE |
| 246 | PEARSON | PEARSON |
| 247 | PENDIENTE | SLOPE |
| 248 | PERCENTIL | PERCENTILE |
| 249 | PERMUTACIONES | PERMUT |
| 250 | PERSONALIZAR.DESHACER | CUSTOM.UNDO |
| 251 | PERSONALIZAR.REPETIR | CUSTOM.REPEAT |
| 252 | PI | PI |
| 253 | POISSON | POISSON |
| 254 | POSICIONA | FPOS |
| 255 | POTENCIA | POWER |
| 256 | PRESIONAR.HERRAMIENTA | PRESS.TOOL |
| 257 | PROBABILIDAD | PROB |
| 258 | PRODUCTO | PRODUCT |
| 259 | PROMEDIO | AVERAGE |
| 260 | PRONOSTICO | FORECAST |
| 261 | PRUEBA.CHI | CHITEST |
| 262 | PRUEBA.CHI.INV | CHIINV |
| 263 | PRUEBA.F | FTEST |
| 264 | PRUEBA.FISHER.INV | FISHERINV |
| 265 | PRUEBA.T | TTEST |
| 266 | PRUEBA.Z | ZTEST |
| 267 | RADIANES | RADIANS |
| 268 | RAIZ | SQRT |
| 269 | RANGO.PERCENTIL | PERCENTRANK |
| 270 | REANUDAR | RESUME |
| 271 | REDONDEA.IMPAR | ODD |
| 272 | REDONDEA.PAR | EVEN |
| 273 | REDONDEAR | ROUND |
| 274 | REDONDEAR.MAS | ROUNDUP |
| 275 | REDONDEAR.MENOS | ROUNDDOWN |
| 276 | REEMPLAZAR | REPLACE |
| 277 | REEMPLAZARB | REPLACEB |
| 278 | REFABS | ABSREF |
| 279 | REFREL | RELREF |
| 280 | REFTEXTO | REFTEXT |
| 281 | REGISTRAR | REGISTER |
| 282 | REINICIAR | RESTART |
| 283 | REPETIR | REPT |
| 284 | RESIDUO | MOD |
| 285 | RESTABLECER.BARRA | RESET.TOOLBAR |
| 286 | RESULTADO | RESULT |
| 287 | REVISION.ORTOGRAFICA | SPELLING.CHECK |
| 288 | SEGUNDO | SECOND |
| 289 | SELECCION | SELECTION |
| 290 | SENO | SIN |
| 291 | SENOH | SINH |
| 292 | SERIES | SERIES |
| 293 | SI | IF |
| 294 | SIFECHA | DATEDIF |
| 295 | SIGNO | SIGN |
| 296 | SLN | SLN |
| 297 | SOLICITAR | REQUEST |
| 298 | SUBTOTALES | SUBTOTAL |
| 299 | SUMA | SUM |
| 300 | SUMA.CUADRADOS | SUMSQ |
| 301 | SUMAPRODUCTO | SUMPRODUCT |
| 302 | SUMAR.SI | SUMIF |
| 303 | SUMAX2MASY2 | SUMX2PY2 |
| 304 | SUMAX2MENOSY2 | SUMX2MY2 |
| 305 | SUMAXMENOSY2 | SUMXMY2 |
| 306 | SUSTITUIR | SUBSTITUTE |
| 307 | SYD | SYD |
| 308 | T | T |
| 309 | TABLA.DI.ADICIONAR.DATOS | PIVOT.ADD.DATA |
| 310 | TAMAÑOA | FSIZE |
| 311 | TAN | TAN |
| 312 | TANH | TANH |
| 313 | TASA | RATE |
| 314 | TENDENCIA | TREND |
| 315 | TERMINAR | TERMINATE |
| 316 | TEXTO | TEXT |
| 317 | TEXTOREF | TEXTREF |
| 318 | TIPO | TYPE |
| 319 | TIPO.DE.ERROR | ERROR.TYPE |
| 320 | TIR | IRR |
| 321 | TIRM | MIRR |
| 322 | TRANSFERIR | POKE |
| 323 | TRANSPONER | TRANSPOSE |
| 324 | TRUNCAR | TRUNC |
| 325 | ULTIMO.ERROR | LAST.ERROR |
| 326 | USDOLLAR | USDOLLAR |
| 327 | VA | PV |
| 328 | VALOR | VALUE |
| 329 | VALREF | DEREF |
| 330 | VAR | VAR |
| 331 | VARP | VARP |
| 332 | VENTANA.TITULO | WINDOW.TITLE |
| 333 | VENTANAS | WINDOWS |
| 334 | VF | FV |
| 335 | VINCULOS | LINKS |
| 336 | VNA | NPV |
| 337 | VOLATIL | VOLATILE |
| 338 | Y | AND |
| 339 | FALSO | FALSE |
| 340 | VERDADERO | TRUE |
Necesitas Ayuda?