How to Multiply the Quantity to Get a Price in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

If you know the unit cost and the quantity of units you are buying, you can use Excel to automatically calculate the total cost for the order. By performing the calculation in Excel, you can update and change either the quantity purchased or the unit cost to update the total cost of the purchase. This is useful for an invoice spreadsheet so you do not need to recreate an invoice for each purchase.

Advertisement

Step 1

Type "Order Quantity" in cell A1.

Video of the Day

Step 2

Type "Unit Price" in cell A2.

Step 3

Type "Total Cost" in cell A3.

Advertisement

Step 4

Enter the quantity purchased in cell B1.

Advertisement

Step 5

Enter the unit price in cell B2.

Step 6

Type "=B1*B2" in cell B3.

Video of the Day

Advertisement

Advertisement

references