How do you perform multiplication in a spread sheet?

Answer 1

To carry out the multiplication directly in the cell type in the formula preceded by = and using asterisks (*) for the multiplication symbol. For example, =240*4.

To multiply the contents of two existing cells use a formula similar to =B12*C12. To avoid mistakes click on the cell in question, rather than typing its address.

Answer 2

Depending on what you want to multiply...

=sum(a3*1.5) would multiply the contents of cell a3 by 1.5

=sum( a4*b16) would yield the result of multiplying a3 by whatever is in cell b16

Answer 3

You have to combine the numbers you would like to multiply with the "asterisk" symbol (*). For example; =F9*G5
If you want to multiply cells B3 and C12, you use the formula =B3*C12.

Answer 4

Start the formula in any cell with the = sign. Then use the * symbol for the multiplication sign. For example, if you want 4 times 3, you will enter =4*3 in a cell in excel.

If you want to multiply a number already in another cell, just enter that cell number instead of the actual number.

Answer 5

Type a number in cell A1, type a number in cell A2. Move to cell A3. In the formula bar above the spreadsheet type =A1*A2 and press enter. The result will be displayed in A3

Answer 6

To multiply the contents of cell A1 and B1 use the following formula:

=A1*B1

Answer 7

The symbol for multiplication is *. If you want to multiply the contents of cell A1 with the contents of cell A2 and display the result in A3, enter the following formula in A3:

=A1*A2