It is difficult to predict which formulas will be the most popular in 2023, as it will depend on the specific needs and uses of Excel users at that time. However, some commonly used and useful Excel formulas include:
- SUM: calculates the sum of a range of cells
- COUNT: counts the number of cells in a range that contain numbers
- AVERAGE: calculates the average of a range of cells
- IF: performs a logical test and returns one value if the test is true and another value if the test is false
- VLOOKUP: looks up a value in a table and returns a corresponding value from a specified column
- INDEX/MATCH: a combination of the INDEX and MATCH functions, which can be used to perform more advanced lookups and reference data from multiple worksheets
- MAX/MIN: returns the largest or smallest value in a range of cells
- CONCATENATE: combines text from multiple cells into one cell
- LEFT/RIGHT/MID: extract characters from a text string
- ROUND: rounds a number to a specified number of digits
These are the most common and useful formulas that are widely used in Excel. It could be different depending on the specific task and data you have.