1. You can multiply using the formula, and multiply the values in cells A1, A2, and A3.
2. If you think, this formula is too long. Use the PRODUCT function to short your formula. For example, the PRODUCT function multiplies the values in the range A1:A5.
3. Here you can see another example.
Explanation: =A1*A2*A3*A4*A5*A6*A7*B1*B2*B3*B4*C1 produces the exact result.
Take a look at the below. To multiply two columns together, complete the steps.
4. Multiply the value in cell A1 by the value in cell B1.
4a. Select cell C1, and the lower right corner of cell C1, and drag it down to cell C6.
Take a look at the below. To multiply a column of numbers by a regular number, complete the steps.
6. Multiply the value in cell A1 by the value in cell A9. Fix the connection to cell A9 by placing a symbol($) in front of the column letter and row number($A$9).
Select cell B1, select the lower right corner of cell B1 and drag it down to cell B6.
Explanation: when we drag the formula down, the absolute reference ($A$9) remains exact, while the relative reference (A1) changes to A2, A3, A4, etc.