How to Multiply the Quantity to Get a Price in Excel

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.

Step

Type "Order Quantity" in cell A1.

Step

Type "Unit Price" in cell A2.

Step

Type "Total Cost" in cell A3.

Step

Enter the quantity purchased in cell B1.

Step

Enter the unit price in cell B2.

Step

Type "=B1*B2" in cell B3.