100 Most important Excel formulas

 Here are 100 common HTML tags along with their typical uses:

1. =SUM(range): Adds up all numbers in a range.
2. =AVERAGE(range): Calculates the average of numbers in a range.
3. =COUNT(range): Counts the number of cells with numbers in a range.
4. =MIN(range): Finds the smallest number in a range.
5. =MAX(range): Finds the largest number in a range.
6. =IF(logical_test, value_if_true, value_if_false): Returns one value if a condition is true and another if false.
7. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]): Searches for a value in a table and returns a corresponding value.
8. =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]): Searches for a value in a table's top row and returns a corresponding value.
9. =INDEX(array, row_num, [column_num]): Returns the value at a specified position in a range.
10. =MATCH(lookup_value, lookup_array, [match_type]): Searches for a value in a range and returns its relative position.
11. =CONCATENATE(text1, [text2], ...): Combines two or more strings of text.
12. =LEFT(text, [num_chars]): Returns a specified number of characters from the beginning of a text string.
13. =RIGHT(text, [num_chars]): Returns a specified number of characters from the end of a text string.
14. =LEN(text): Returns the number of characters in a text string.
15. =TRIM(text): Removes extra spaces from a text string.
16. =UPPER(text): Converts text to uppercase.
17. =LOWER(text): Converts text to lowercase.
18. =PROPER(text): Capitalizes the first letter of each word in a text string.
19. =TEXT(value, format_text): Converts a value to text using a specified format.
20. =NOW(): Returns the current date and time.
21. =TODAY(): Returns the current date.
22. =YEAR(date): Returns the year from a date.
23. =MONTH(date): Returns the month from a date.
24. =DAY(date): Returns the day from a date.
25. =DATE(year, month, day): Returns a date based on specified year, month, and day values.
26. =TIME(hour, minute, second): Returns a time based on specified hour, minute, and second values.
27. =SUMIF(range, criteria, [sum_range]): Adds up numbers in a range based on a given condition.
28. =COUNTIF(range, criteria): Counts cells in a range based on a given condition.
29. =AVERAGEIF(range, criteria, [average_range]): Calculates the average of numbers in a range based on a given condition.
30. =IFERROR(value, value_if_error): Returns a specified value if a formula results in an error.
31. =IFNA(value, value_if_na): Returns a specified value if a formula results in #N/A.
32. =IFBLANK(value, value_if_blank): Returns a specified value if a cell is empty.
33. =INDEX(MATCH()): A combination to look up a value in a range based on a condition.
34. =CHOOSE(index_num, value1, [value2], ...): Returns a value from a list based on an index number.
35. =SUMPRODUCT(array1, [array2], ...): Returns the sum of the product of corresponding array elements.
36. =ROUND(number, num_digits): Rounds a number to a specified number of digits.
37. =ROUNDUP(number, num_digits): Rounds a number up, away from zero.
38. =ROUNDDOWN(number, num_digits): Rounds a number down, towards zero.
39. =INT(number): Rounds a number down to the nearest integer.
40. =MOD(number, divisor): Returns the remainder of a division.
41. =ABS(number): Returns the absolute value of a number.
42. =SQRT(number): Returns the square root of a number.
43. =POWER(number, exponent): Raises a number to a power.
44. =LOG(number, [base]): Returns the logarithm of a number to a specified base.
45. =EXP(number): Returns e raised to the power of a given number.
46. =RAND(): Returns a random number between 0 and 1.
47. =RANDBETWEEN(bottom, top): Returns a random number within a specified range.
48. =COUNTA(range): Counts the number of non-empty cells in a range.
49. =SUBTOTAL(function_num, ref1, [ref2], ...): Performs a subtotal calculation on a range.
50. =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...): Adds up numbers based on multiple conditions.
51. =COUNTIFS(criteria_range1, criteria1, [criteria_range2], [criteria2], ...): Counts cells based on multiple conditions.
52. =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...): Calculates the average based on multiple conditions.
53. =IF(logical_test, value_if_true, [value_if_false]): Another form of the IF function.
54. =IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...): Tests multiple conditions and returns the corresponding value for the first true condition.
55. =SWITCH(expression, value1, result1, [value2, result2], ...): Compares an expression against multiple values and returns the corresponding result for the first match.
56. =SUMPRODUCT(SUMIF()): A combination of SUMPRODUCT and SUMIF.
57. =HYPERLINK(link_location, [friendly_name]): Creates a hyperlink.
58. =INDIRECT(ref_text, [a1]): Returns the value specified by a text string.
59. =MATCH(lookup_value, lookup_array, [match_type]): Searches for a value in a range and returns its relative position.
60. =HYPERLINK(link_location, [friendly_name]): Creates a hyperlink.
61. =INDIRECT(ref_text, [a1]): Returns the value specified by a text string.
62. =MATCH(lookup_value, lookup_array, [match_type]): Searches for a value in a range and returns its relative position.
63. =INDEX(MATCH()): A combination to look up a value in a range based on a condition.
64. =CHOOSE(index_num, value1, [value2], ...): Returns a value from a list based on an index number.
65. =SUMPRODUCT(array1, [array2], ...): Returns the sum of the product of corresponding array elements.

66. =TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...): Combines text from multiple ranges or strings using a specified delimiter.
67. =SUBSTITUTE(text, old_text, new_text, [instance_num]): Replaces occurrences of a specified substring with another in a text string.
68. =REPLACE(old_text, start_num, num_chars, new_text): Replaces part of a text string with another text string.
69. =CLEAN(text): Removes non-printable characters from text.
70. =UNIQUE(range): Returns unique values from a range.
71. =SORT(range, [sort_column], [sort_order], [custom_headers]): Sorts a range of values.
72. =FILTER(range, criteria): Filters a range of values based on specified criteria.
73. =TRANSPOSE(array): Transposes rows and columns in a range.
74. =COUNTUNIQUE(range1, [range2], ...): Counts the number of unique values in multiple ranges.
75. =IFERROR(value, value_if_error): Returns a specified value if a formula results in an error.
76. =IFNA(value, value_if_na): Returns a specified value if a formula results in #N/A.
77. =IFERROR(value, value_if_error): Returns a specified value if a formula results in an error.
78. =SEQUENCE(rows, [columns], [start], [step]): Generates a sequence of numbers.
79. =RANDARRAY(rows, [columns], [min], [max]): Generates an array of random numbers.
80. =UNION(range1, [range2], ...): Combines multiple ranges into one.
81. =WEBSERVICE(url): Retrieves data from a web service.
82. =FILTERXML(xml, xpath) - Extracts data from XML using XPath.
83. =HYPERLINK(link_location, [friendly_name]): Creates a hyperlink.
84. =INDIRECT(ref_text, [a1]): Returns the value specified by a text string.
85. =MATCH(lookup_value, lookup_array, [match_type]): Searches for a value in a range and returns its relative position.
86. =INDEX(MATCH()): A combination to look up a value in a range based on a condition.
87. =CHOOSE(index_num, value1, [value2], ...): Returns a value from a list based on an index number.
88. =SUMPRODUCT(array1, [array2], ...): Returns the sum of the product of corresponding array elements.
89. =HYPERLINK(link_location, [friendly_name]): Creates a hyperlink.
90. =INDIRECT(ref_text, [a1]): Returns the value specified by a text string.
91. =MATCH(lookup_value, lookup_array, [match_type]): Searches for a value in a range and returns its relative position.
92. =INDEX(MATCH()): A combination to look up a value in a range based on a condition.
93. =CHOOSE(index_num, value1, [value2], ...): Returns a value from a list based on an index number.
94. =SUMPRODUCT(array1, [array2], ...): Returns the sum of the product of corresponding array elements.
95. =SEQUENCE(rows, [columns], [start], [step]): Generates a sequence of numbers.
96. =RANDARRAY(rows, [columns], [min], [max]): Generates an array of random numbers.
97. =UNION(range1, [range2], ...): Combines multiple ranges into one.
98. =WEBSERVICE(url): Retrieves data from a web service.
99. =FILTERXML(xml, xpath): Extracts data from XML using XPath.
100. =MID(text, start_num, num_chars): Returns a specific number of characters from a text string, starting at the position you specify.

These formulas cover