Functional formula for calculating sales volume: sales volume = sales volume × unit price.

Sales function formula is a mathematical formula used to calculate sales value in Excel table. By using these functions, the sales volume can be automatically calculated according to different input data, thus eliminating the tedious process of manual calculation.

SUM function: SUM function is one of the most basic functions in Excel, which can sum the values in a specified cell range. For example, if you want to calculate the total sales within A 1 to A 10, you can use the following formula: = sum (A 1: A 10).

IF function: IF function can be used to set conditions and return different results. Can automatically calculate the sales of different intervals according to the specific situation. For example, if you want to judge whether you get a bonus according to whether the sales amount exceeds 1000 yuan, you can use the following formula: = if (a1> 1000, with bonus, without bonus).

VLOOKUP function: VLOOKUP function is used to search a certain value in a certain range and return the corresponding results. You can automatically find the corresponding sales data according to the specific product name. For example, if you want to find the corresponding sales data according to the product name, you can use the following formula: =VLOOKUP (product name, a1:b10,2, FALSE).

Development history

The word "function" used in China's math book is translated. It was Li, an algebra expert in China's Qing Dynasty, who translated "function" into "function" when he translated the book Algebra 1859.

In ancient China, the word "Xin" and the word "Han" were universal and both had the meaning of "Han". Li's definition is: "every formula contains heaven, which is a function of heaven." In ancient China, four words were used to represent four different unknowns or variables: heaven, earth, people and things. The meaning of this definition is: "Whenever a formula contains the variable X, the formula is called a function of X."

So "function" means that the formula contains variables. The exact definition of an equation refers to an equation containing unknowns. However, in the early mathematical monograph "Nine Chapters Arithmetic" in China, the term equation refers to simultaneous linear equations with many unknowns, which are called linear equations.