Question: how do you create a multiplication formula in excel?
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.