how to multiply two columns in excel for mac

The formula is copied there, and automatically adjusts the cell references.

The cell outline shows a square in the lower-right corner, called the fill handle.ĭrag the fill handle to an adjacent cell. Once you do, the formula automatically adjusts to calculate the values in the corresponding row or column. Note: You can use variations on this formula for all basic math calculations in Excel.Īfter you create a formula, you can easily drag it into adjacent cells, either in a row or column. If you use the example numbers, the results are 25, -15, 100, and 0.25 For example, A1 + B1.Īfter you have tried the formula with a plus sign (+), type a minus sign (-) to subtract values, an asterisk (*) to multiply values, and a forward slash (/) to divide values.

But to create a formula that you would not have to change, even if you change one of the values, type the cell reference and a math operator. Using a cell reference in a formula ensures that the result is updated if the values change.įor example, in cell A1, type 5, and in cell B1, type 20.Ĭlick any blank cell, and then type an equal sign ( =) to start a formula.Īfter the equal sign (=), you can type two numbers and a math operator to create a simple formula.įor example, you could simply type =5+20, or =5*20. Instead of entering values directly into the formula, you can also refer to the cells that contain the values that you want to calculate. To create a simple formula, you enter values and math operators into a cell, or the formula bar, to receive a result. Use a simple formula to add, subtract, multiply, or divide numeric values

You can also enter a formula that uses the SUM function to quickly total a series of values without having to enter any of them manually in a formula. Once you have created a formula, you can fill it into adjacent cells - no need to create the same formula over and over again. On a sheet, you can enter simple formulas to add, subtract, multiply, and divide two or more numeric values. Instead of reaching for your calculator, use Excel to do the math!

How to multiply two columns in excel for mac