Simple multiplication table
BeginnerWhen you have a list of items with a quantity and a unit price, you can calculate the extended cost (line total) with multiplication. This is a common pattern in quotes, invoices, and simple sales summaries.
In Excel, you can multiply values in two common ways:
- Use the multiplication operator:
=A2*B2 - Use the PRODUCT function:
=PRODUCT(number1, number2)
What you need to do
- Click cell D2 (the first cell under Extended cost ($)).
- Enter a formula that multiplies the quantity in B2 by the unit price in C2.
- Press Enter to calculate the line total.
- Copy your formula down through D7 so every item has an extended cost.
To copy down, select D2 and drag the small square at the bottom-right corner of the cell down to cell D7.
Goal
Cells D2:D7 should contain the extended cost for each line item (quantity × unit price).
Need some help?
Hint 1
Use relative references (no $ signs) so the row numbers change automatically when you copy the formula to the rows below.
Hint 2
In D2, the two inputs you need are the Quantity in B2 and the Unit price in C2. A correct formula should evaluate to 75 in D2.
Related function(s)
Simple multiplication table
BeginnerWhen you have a list of items with a quantity and a unit price, you can calculate the extended cost (line total) with multiplication. This is a common pattern in quotes, invoices, and simple sales summaries.
In Excel, you can multiply values in two common ways:
- Use the multiplication operator:
=A2*B2 - Use the PRODUCT function:
=PRODUCT(number1, number2)
What you need to do
- Click cell D2 (the first cell under Extended cost ($)).
- Enter a formula that multiplies the quantity in B2 by the unit price in C2.
- Press Enter to calculate the line total.
- Copy your formula down through D7 so every item has an extended cost.
To copy down, select D2 and drag the small square at the bottom-right corner of the cell down to cell D7.
Goal
Cells D2:D7 should contain the extended cost for each line item (quantity × unit price).
Need some help?
Hint 1
Use relative references (no $ signs) so the row numbers change automatically when you copy the formula to the rows below.
Hint 2
In D2, the two inputs you need are the Quantity in B2 and the Unit price in C2. A correct formula should evaluate to 75 in D2.