Question: what is the formula for multiplication in excel?
Answer: Multiply a column of numbers by a constant number In this example, the number you want to multiply by is 3, contained in cell C2. 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.