How to use Excel multiplication function

php editor Xigua will help you easily master the use of Excel's multiplication function. In Excel, the multiplication function can help us quickly calculate the result of multiplying multiple numbers and improve work efficiency. With simple operations, you can easily complete complex computing tasks, saving time and energy. Let us learn together how to correctly use the Excel multiplication function to improve work efficiency and complete various calculation tasks!

1. First, we open an EXCEL table. We want to calculate the total price of each fruit, then we need to use unit price * quantity, (as shown in the figure below).

2. Then, we enter the multiplication function [=B2*C2] in row D2 of the table, and then click the Enter key [Enter] on the keyboard (as shown below) The part circled in red).

3. Next, you can see that column D2 has been calculated. Place the mouse on the lower right corner of the cell and it will turn into a [black plus sign], and pull it down. You can fill in the following data (as shown in the red circle in the figure below).

#4. Finally, we can calculate the total price in the table. Here we use the Excel multiplication function, and we are done.

The above is the detailed content of How to use Excel multiplication function. For more information, please follow other related articles on the PHP Chinese website!