Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to set up my spreadsheet to calculate the product (column K) by multiplying the price of an item (column I) by the quantity purchased (column J).

i.e. every price point in column 'I' to be multiplied by every quantity in column 'J' and the total to be given in column 'K'


I*J=K 5.99 * 1 = 5.99 1.99 * 2 = 3.98 etc

share|improve this question

You've almost written the required formula already. If you put the formula:


... into cell K1, and if you've got 5.99 in cell I1 and 1 in J1, then 5.99 will appear in cell K1. If you Copy and Paste cell K1 into cells K2 and below, the same computation can be done as far down column K as you would like.

You'll probably make quicker progress if you press the F1 key in Excel, then type "Formula" into the Help search box and select "Create a formula". The Help system will guide you through learning how to write formulas.

share|improve this answer
+1 for "The Help system will guides you through learning how to write formulas." – CharlieRB Jan 24 '13 at 12:30
Perfect. Thanks. – B. Shelton Jan 25 '13 at 2:47
@B.Shelton: If this is the answer you need, could you click on the tick mark to accept and close this question? Thanks. Glad to help. – Simon Jan 25 '13 at 4:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.