As soon as you do this, Excel will enclose the formula in, which is an indication of an array formula. Type the formula in the formula bar, and press Ctrl + Shift + Enter.Select the entire range where you want to enter the formula (D2:D5).To insert this multiplication formula in your worksheets, perform these steps: You simply write down the ranges you want to multiply separated by the multiplication sign, like this: This one is very straightforward and easy to use. Please don't feel discouraged or intimidated by the words "array formula". One more way to multiply entire columns in Excel is by using an array formula.
#SET UP A MULTIPLY FORMULA FOR A COLUMN IN EXCEL ON MY MAC HOW TO#
How to multiply two columns with an array formula You enter the formula in the first cell, and then copy it down the column as explained in the above example: If you prefer working with Excel functions rather than expressions, you can multiply 2 columns by using the PRODUCT function, which is a specially designed to do multiplication in Excel.įor our sample data set, the formula goes as follows:Īs with the multiply symbol, the key point is using relative cell references, so that the formula can adjust properly for each row. How to multiply two columns with PRODUCT function For example, the formula in D3 changes to =B3*C3, the formula in D3 becomes =B4*C4, and so on. Since you use relative cell references (without the $ sign) in the formula, the references will change based on a relative position of the row where the formula is copied. Double-click the small green square in the lower-right corner of D2 to copy the formula down the column, until the last cell with data.
The multiplication formula you put in D2 is as plain as this: =B2*C2 Supposing, your data begins in row 2, with B and C being the columns to be multiplied. The easiest way to multiply 2 columns in Excel is by making a simple formula with the multiplication symbol (*).
How to multiply one column by another with multiplication operator Below, we will show you three possible solutions so you can choose the one that works best for you.
In this tutorial, we will take a step further and look at how you can quickly multiply entire columns. In our last tutorial, we discussed how to multiply cells in Excel. Microsoft Excel is primarily designed to manipulate numbers, so it provides a handful of different ways to perform basic math operations as well as more complex calculations.
0 kommentar(er)
