Home >Topics >excel >What is the formula of multiplication function in excel

What is the formula of multiplication function in excel

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-12 15:31:29194432browse

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.

What is the formula of multiplication function in excel

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.

What is the formula of multiplication function in excel

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.

What is the formula of multiplication function in excel

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.

What is the formula of multiplication function in excel

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.

What is the formula of multiplication function in excel

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

What is the formula of multiplication function in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn