Formulas for multiplication of numbers in Excel

Multiplying numbers in the same cell
To use this Use the mathematical factor * (asterisk).
For example, if you type =5*10 in a cell.

The cell will display a result of 50.

Multiplying a column of numbers by using constant numbers
Let's say you want to multiply each cell in a column of seven numbers by a number that is in another cell. in this example The number you want to multiply, 2, is listed in cell C2.

1. Type =A2*$B$2 in a new column in your spreadsheet. (The example above uses column C.) Make sure to include the $ symbol before B and before 2 in the formula, and then press ENTER.

note: Using the $ symbol tells Excel that references to B2 are "absolute", which means When you copy a formula to another cell The reference is always to cell B2.

If you don't use the $ symbol in a formula and drag the formula down to cell B3, Excel changes the formula to =A3*B3, which won't work. because there is a value in B3

2. Drag the formula down to another cell in the column.

note: In an Excel 2016 for Windows cell, the cell is automatically populated.

Multiply numbers between cells using a formula

You can use the PRODUCT function to multiply numbers, cells, and cell ranges.
You can use up to 255 combinations of numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells ( A2 and G4)
Two numbers (12 and 150) and three intervals (A4:A15, E3:E5 and H4:J6).