What is the formula of multiplication function in excel

The formula of the multiplication function in excel is "=cell*cell". The specific setting method is: first open the Excel table that needs to be operated, select the specified cell; then enter the formula "=cell*cell" in the cell; and finally press the "Enter key" on the keyboard.

The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.

Open the computer, create a new Excel table, and double-click to open it, as shown in the figure below.

After opening the Excel table, we create a new part-time salary table. The table contains employee numbers, unit prices and working days. We need to calculate the wages of the corresponding part-time employees.

Many people who don’t understand will use a calculator to calculate and fill in the form, which is very troublesome and inefficient. We only need to use the multiplication formula in the Excel spreadsheet. Use "=B3*C3" to calculate the salary of an individual employee.

After writing the formula, click anywhere in the Excel table, and the formula will display the calculated result. The salary of employee number 1 for the current month is 3,600.

Select the cell where the salary of employee number 1 is located, click and hold the lower right position, and then drag down.

Drag to the salary cell where employee number 10 is located and release the mouse button. Then the salaries of other part-time employees will be calculated. It is very convenient and practical.

Related learning recommendations: excel tutorial

The above is the detailed content of What is the formula of multiplication function in excel. For more information, please follow other related articles on the PHP Chinese website!