1, EXCEL formula: the equation of numerical calculation in Excel worksheet.

2.Excel function: it is a built-in function of Excel.

Second, the characteristics are different.

1, Excel formula: formula input starts with "=". Simple formulas include addition, subtraction, multiplication and division.

2.Excel function: used to create a single formula, which can generate multiple results or operate on a set of parameters stored in rows and columns.

Third, the composition is different.

1, Excel formula: This formula is a series of formula expressions, which usually contains a set of functions, operators and constants.

2.Excel function: * * * contains 1 1 class, which are database function, date and time function, engineering function, financial function, information function, logic function, query and reference function, mathematical and trigonometric function, statistical function, text function and user-defined function respectively.

Baidu Encyclopedia -excel Function

Baidu Encyclopedia -EXCEL Formula