Question: how to make a formula in excel for multiplication?
Answer: Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER. ... 
Drag the formula down to the other cells in the column.