Question: what is the formula for multiplying columns in excel?
Answer: Multiply a column of numbers by a constant number 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.