Multiplying in Excel?

Question

Is there a formula to mulitply the values in cells in column A by values in cells in column B? I mean for example =(A1*B1), =(A2*B2) etc. Can I type in the formula that would work for all the cells instead of doing it separately for the each one multipication?

Answer 1

If you type the formula into one cell then take the cursor to the left hand bott corner of that cell until you get a small black cross click on that and drag it down the column, the formula will copy into each cell and magically change the cell references to suit the new location.

Answer 2

Yes, presuming you want the formula in column c, click in C1, type = then click in cell a1 to put the value form that cell in, click on the asterisk key * which as you know is the multiplication symbol, then click in cell B2 to complete the formula. Then get your mouse pointer onto the bottom righthand corner of cell c1, your mouse pointer turns to a small black cross, now drag down to the bottom of that column so the first reference =A1*B1 is replicated or autofilled down, flipping over to =A2*B2, =A3*B3 etc. This is what relative formulae are all about. Once you have input the first formula, assuming you want the same type of calculation in the other cells, you simply autofill down in this way.

Answer 3

Type the formula in one cell, C1 for example. In your example this would be =A1*B1

Move the cursor to the bottom RIGHT corner of the cell and you will see the cursor change to a black + sign. This is the Fill Handle.

Click and drag this handle down and all the cells will have the correct formula filled relative to the original cells. Just like you wanted.

You do not need to select the cell.

The Fill handle also works dragging up or right or left.

Answer 4

Yes, for multiplying cell A1 by cell B1, type '=A1*B1'. If you want to repeat this down the column (A2, A3,...), grab the lower right hand corner of the cell containing the formula and drag it down the column.
There are some settings in Excel that might mess this up, but those are the basics.

Answer 5

You can do this by selecting the first cells then when the cross shows, fill the following cells by dragging the cursor, this will format the cells - A1*B1 - A2*B2 - and on and on and on

Answer 6

Select "=" then first cell, then input X and then the cell to be multiplied by the first cell.

To replicate this for similar groups of cell(s) just copy the formula established and paste onto the first cell(s) of the next cell(s) you wish to use.

Note that the cells to which you wish to copy to must be in the same spacial relationship as the cells from which you are copying.

Answer 7

The forumla you need is:

=$a1*$b1

After typing that in, you can copy and paste it into any cells you'd like to multiply the A & B columns together. (If you want it to adjust to different columns, remove the $ before copying.)

Answer 8

If i'm understanding you right, enter the formula SUM= and whatever sum you want and just drag it from the bottom right corner of the cell or you should be able to copy & paste the sum

Answer 9

Use the * to multiply. e.g. =2*3 interior the cellular would make the cellular say 6. in case you opt to take off the %, then proper click the cellular, "format cells", "variety", then choose "everyday" because of the fact the variety. All it is from memory, so the menus may be named slightly in a diverse way...

Answer 10

Yes spreadsheets use a system called relative referencing

just stick in your formula and copy it all the way down