Visión General
¡Felicidades por completar Excel Formulas! 🎉
| Mathematical Formulas | ||
| SUM | =SUM(range) - Adds all the numbers in a range of cells | |
| MULTIPLY | =A1 * B1 - Multiplies the values in cells A1 and B1 | |
| SUBTRACT | =A1 - B1 - Subtracts the value in cell B1 from the value in cell A1 | |
| DIVIDE | =A1 / B1 - Divides the value in cell A1 by the value in cell B1 | |
| Statistical Formulas | ||
| MEAN | =AVERAGE(range) - Calculates the average of a range of numbers | |
| MAX | =MAX(range) - Returns the maximum value in a range of numbers | |
| MIN | =MIN(range) - Returns the minimum value in a range of numbers | |
| AVERAGE | =AVERAGE(range) - Calculates the average of a range of numbers | |
| MEDIAN | =MEDIAN(range) - Returns the median of a range of numbers | |
| Lookup and Reference Formulas | ||
| MATCH | =MATCH(lookup_value, lookup_array, [match_type]) - Finds the position of a value in a range | |
| CHOOSE | =CHOOSE(index_num, value1, [value2], ...) - Chooses a value from a list based on an index number | |
| INDIRECT | =INDIRECT(ref_text, [a1]) - Returns the reference specified by a text string | |
| VLOOKUP | =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) - Looks up a value in the first column of a table and returns a value in the same row from a specified column | |
| XLOOKUP | =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) - Searches a range or an array, and returns an item corresponding to the first match it finds | |
| Array Formulas | ||
| UNIQUE | =UNIQUE(range) - Extracts unique values from a range | |
| SORT | =SORT(range) - Sorts the contents of a range | |
| FILTER | =FILTER(range, condition) - Filters a range based on a condition | |
| TRANSPOSE | =TRANSPOSE(range) - Transposes the rows and columns of a range |
Por supuesto, estas no son todas las fórmulas que Excel puede ofrecer, pero ahora has aprendido los conceptos básicos de las fórmulas y las más populares y cómo funcionan. Con ellas podrás resolver el 80% de los problemas y tareas diarias.
¡Gracias por tus comentarios!
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Can you explain how to use one of these formulas with an example?
What are some tips for remembering these formulas?
Are there any common mistakes to avoid when using these formulas?
Awesome!
Completion rate improved to 6.67Visión General
Desliza para mostrar el menú
¡Felicidades por completar Excel Formulas! 🎉
| Mathematical Formulas | ||
| SUM | =SUM(range) - Adds all the numbers in a range of cells | |
| MULTIPLY | =A1 * B1 - Multiplies the values in cells A1 and B1 | |
| SUBTRACT | =A1 - B1 - Subtracts the value in cell B1 from the value in cell A1 | |
| DIVIDE | =A1 / B1 - Divides the value in cell A1 by the value in cell B1 | |
| Statistical Formulas | ||
| MEAN | =AVERAGE(range) - Calculates the average of a range of numbers | |
| MAX | =MAX(range) - Returns the maximum value in a range of numbers | |
| MIN | =MIN(range) - Returns the minimum value in a range of numbers | |
| AVERAGE | =AVERAGE(range) - Calculates the average of a range of numbers | |
| MEDIAN | =MEDIAN(range) - Returns the median of a range of numbers | |
| Lookup and Reference Formulas | ||
| MATCH | =MATCH(lookup_value, lookup_array, [match_type]) - Finds the position of a value in a range | |
| CHOOSE | =CHOOSE(index_num, value1, [value2], ...) - Chooses a value from a list based on an index number | |
| INDIRECT | =INDIRECT(ref_text, [a1]) - Returns the reference specified by a text string | |
| VLOOKUP | =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) - Looks up a value in the first column of a table and returns a value in the same row from a specified column | |
| XLOOKUP | =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) - Searches a range or an array, and returns an item corresponding to the first match it finds | |
| Array Formulas | ||
| UNIQUE | =UNIQUE(range) - Extracts unique values from a range | |
| SORT | =SORT(range) - Sorts the contents of a range | |
| FILTER | =FILTER(range, condition) - Filters a range based on a condition | |
| TRANSPOSE | =TRANSPOSE(range) - Transposes the rows and columns of a range |
Por supuesto, estas no son todas las fórmulas que Excel puede ofrecer, pero ahora has aprendido los conceptos básicos de las fórmulas y las más populares y cómo funcionan. Con ellas podrás resolver el 80% de los problemas y tareas diarias.
¡Gracias por tus comentarios!
