Current location - Training Enrollment Network - Books and materials - How to enter the unit price and quantity in EXCEL to find the total price?
How to enter the unit price and quantity in EXCEL to find the total price?
The specific operation method is as follows:

1. Open the file to be operated, as shown in the following figure. Column A is the unit price of the commodity, column B is the quantity of the commodity, and column C is the total price of each commodity, as shown in the following figure:

2. Enter "= A2 * B2" and "= A3 * A3" in C2 and C3 cells respectively, as shown in the following figure:

3. Select cells C2 and C3, place the cursor in the lower right corner of C3 until the mouse becomes a black cross, and then drag it down to get the total price of all goods, as shown in the following figure: