Excel function is a predefined special formula, which is used to perform data processing tasks such as calculation and analysis. Take the commonly used summation function SUM as an example, which

The grammar is "SUM(number 1, number2, ...)", where "SUM" is called the function name, and a function has only one name, which determines the function and purpose.

Way. The function name is followed by a left parenthesis, followed by the contents called parameters separated by commas, and finally by a right parenthesis, indicating the end of the function.

Parameter is the most complex part of a function, which specifies the operation object, order or structure of the function. It enables users to handle a cell or area, such as analyzing deposit interest, determining score ranking, calculating trigonometric function value, etc.

According to the source of functions, Excel functions can be divided into built-in functions and extended functions. As long as Excel is started, users can use it. The latter must be loaded by clicking the "Tools → Plug-ins" menu command before it can be used as a built-in function.

What is a formula?

Functions and formulas are different and interrelated. If the former is a special formula predefined by Excel, then the latter is a formula designed by users for calculating and processing worksheets.

Take the formula "= sum (e1:h1) * a1+26" as an example. It starts with the equal sign "=" and can contain functions, references, operators and constants. In the above formula

"SUM(E 1:H 1)" is a function, "A 1" is a reference to cell A 1 (using the data stored in it), "26" is a constant, and "*" and "+"are arithmetic operators.

Comparison operators, text operators and reference operators).

If a function is to appear as a formula, it must have two components, one is the equal sign before the function name, and the other is the function itself.