To multiply a column of numbers by a constant number, execute the following steps. For example, if you wanted to add up values in cells A4 to A8, and cells B4 and B5, you'd do it like this: Drag the formula down to the other cells in the column. This is where the result of the formula will appear. Multiply and divide numbers in Excel - Multiply numbers Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). You can use PRODUCT in the same way you did for SUM. We will now perform the calculations using the respective arithmetic operators. 5a. Let's start with the one for addition. But Excel 2007 will see the word Product and multiply whatever is between the round brackets. To multiply, then, try this: Click into cell D15 on your spreadsheet, just below your Cost heading. The outlook of Excel will depend on your version. Type = (an equal sign) into cell C1. Type the following formula: Enter the data in your worksheet as shown in the image above. When performing calculations in Excel, you should always start with the equal (=) sign. 6a. Type * (​an asterisk symbol) after cell A1. For example, to multiply the numbers 4, 3 and 10, type the following into any Excel cell: Next, select cell C1, click on the lower right corner of cell C1 and drag it down to cell C6. Create the Formula. Select cell C1 to make it the active cell. First, multiply the value in cell A1 by the value in cell B1. Select cell A2 to enter that cell reference. The simplest way to perform multiplication in Excel is to type in the = sign, followed by two or more numbers, separated by the * operator. Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER. 5b. Now click into the Formula Bar at the top of Excel. Select cell A1 to enter that cell reference into the formula. Take a look at the screenshot below.