Question: what is the formula in excel for multiplication?
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.