What is the most common formula used in Excel?

Answer 1

The most common functions used are ones like SUM, AVERAGE, MAX, MIN, COUNT, COUNTA and many others. It can also depend on the type of spreadsheet that is being created and the type of user. Some people would use spreadsheets for specific purposes so they would commonly use particular functions that others would not use very often. As for formulas, the ones containing some of the listed functions are common, but every spreadsheet has different formulas, so it cannot be really said of formulas as to which are the most popular.

Answer 2

There is no real answer to that, as practically every formula is different. A general type of formula that is very common is to total things up and that is normally done with the SUM function. It can be a common formula in many spreadsheets, but in others it might not appear at all. Even where it is used lots of times in the same spreadsheet, the values or cell references would be different in each variation, so on that basis all the formulas would be different, even if they use the SUM function. So it is hard to say definitively what is the most common formula used.