Categories

How To Multiply In Excel? Best Way To Multiply Various Columns in Excel

How to Multiply in Excel? Microsoft Excel is a software developed by Microsoft for Windows, Android, macOS, and iOS. It is a spreadsheet, that is used to create grids of numbers, text, and perform different calculations.

There is no specific “Excel formula to multiply”. There are a few different ways to multiply numbers and cells.

Different functions and multiplication symbols are used to multiply in Excel. Moreover, you can create a multiplying formula for cells, columns, and ranges.

How to Multiply in Excel

Arithmetic operations can be done in Excel. We will discuss How to Multiply in Excel. Multiplication can be done in cells, a range of cells or multiplying cells.

Multiplication of Numbers

1. Open excel sheet.
2. Click on a Cell.
3. Type  ” = ” in the cell.
4. Without giving a space type a number you want to multiply.
5. Type ” * ” asterisk. This implies you are using multiplication operation.
6. Type the other number.
7. Press Enter. The answer of multiplication will be displayed in a cell.
8. If you click on the cell, the formula of a product will be displayed in the Excel Address Bar.

Explanation Multiplication of Numbers

Let’s assume, I want to multiply 4 and 5 in cell A1. I will type in A1 ” =4*5 ” and press Enter. ” 20 ” will be displayed in A1.

Right above the sheet, you can see Address Bar. In front of ” fx “, you can see the formula that is ” =4*5 ” in this case.

Multiplication of Cells

1. Open excel sheet.
2. Click on a Cell.
3. Type  ” = ” in the cell.
4. Without giving a space type a cell name you want to multiply.
5. Type ” * ” asterisk. This implies you are using multiplication operation.
6. Type the other cell number.
7. Press Enter. The answer of multiplication will be displayed in a cell.
8. If you click on the cell, the formula of a product will be displayed in the Excel Address Bar.

Explanation Of Multiply Function in Excel

Let’s assume, I want to multiply A1 (assume A1 contains 4 ) and C4 (assume C4 contains 5 ) in cell D1. I will type in D1 ” =A1*C4 ” and press Enter. ” 20 ” will be displayed in D1.

Right above the sheet, you can see Address Bar. In front of ” fx “, you can see the formula that is ” =A1*C4 ” in this case.

Multiplying Range of Cells

1. Open excel sheet.
2. Click on a Cell.
3. Type  ” =PRODUCT() ” in the cell. It shows you want to multiply various numbers of cells.
4. Inside the brackets ” () “.
5. Type the first cell name you want multiplication to start from.
6. Type ” : “.
7. Type the last cell number. , it should be from the same row or column as the first cell name.
8. Brackets closed.
9. Press Enter. The answer of multiplication will be displayed in a cell.
10. If you click on the cell, the formula of a product will be displayed in the Excel Address Bar.

Explanation Of Product Function in Excel

Let’s assume, I want to multiply Column A from A1 to A7 (assume cell range contains 4,1,2,3,4,1,2 sequentially) in cell D1. I will type in D1 ” =PRODUCT(A1: A7) ” and press Enter. ” 192 ” will be displayed in D1.
Right above the sheet, you can see Address Bar. In front of ” fx “, you can see the formula that is ” =PRODUCT(A1: A7) ” in this case.

Let’s assume, I want to multiply Row 3 from A3 to E3  (assume cell range contains 4,1,2,3,2 sequentially ) in cell F3. I will type in F3 ” =PRODUCT(A3: E3) ” and press Enter. ” 48 ” will be displayed in F3.
Right above the sheet, you can see Address Bar. In front of ” fx “, you can see the formula that is ” =PRODUCT(A3: E3) ” in this case.

Though, asterisks can also be used. It is time taking to use asterisks for multiplying a range of cells. For the same example as above. I will type in D1 ” =A1:A2:A3:A4:A5:A6: A7 ” for column press Enter. ” 198 ” will be displayed in D1.

The same steps can be used for multiplying rows.

How to Multiply Various Columns in Excel

There are 2 ways to multiply various columns. Choose any of them.

1. Click on the cell.
2. Use the product formula.
• As already mentioned above under the heading Multiplying Range of Cells.
3. An array formula can be used that is “=A1:A3*B1:B3*C1: C3”. Then drag down a small square in the lower right corner.

• It will multiply A1*B1*C1 and a product will be shown in the selected cell. Then in the next column, it will multiply A2*B2*C2. Similarly for the A3*B3*C3.

Multiplying Column with a Constant in Excel

1. Fix a constant you want to multiply with Column in any cell.
2. Click on the cell you want your product to be displayed on.
3. Type ” = “.
4. Type cell number with giving space.
5. Type the cell number containing a constant number.
6. Lock constant number by \$.
7. To copy a formula down the column you can double click on the small green square in a right lower corner of formula cell. Drag down the square as far as you want.

Explanation Multiplying Column with a Constant in Excel

Let’s assume, I want to multiply 0.12  from A3 to C3  (assume cell range contains 0,1,2 sequentially) in cell A4. I will fix the number 0.12 in any cell (say in H2). I will type in A4 ” =A3*\$H\$2 “. Press Enter. ” 0 ” will be displayed in A4.

I will drag the green button on cell A4 towards the right to copy it for cell B3 and C3. By doing so it will display a product of B3*\$H\$2 and C3*\$H\$2 in B4, C4 respectively. These steps can be followed for Column headings too. Then drag vertically to copy the formula.

You can also learn Excel online and even from different institutes. If you want to learn online then you can visit youtube, otherwise, visit teAchnology for tutorials.

I hope you like my post about “How To Multiply In Excel?”. If you want to read more related articles then you can also visit:

By VEQUILL

By profession, I'm a software engineer. Everyone has one strong driving force in self that let one evolve above boundaries, my passion is content creation. Following my ambition, I am founder and CEO at TapeDaily with aim of providing high-quality content and the ultimate goal of reader satisfaction. Consistent improvement has always been my priority. The spark with time ignites more and more and recognized me as one of the leading SEO experts in UAE. I've successfully delivered vast improvements in search engine rankings across a variety of clients and sectors, including property and real estate.
TapeDaily accomplishes all of your daily problems with best solutions. The team is comprised of passionate writers with the particular interest and expertise in respective categories to meet the objective of quality over quantity to provide you spectacular articles of your interest.
"I believe in hidden skills and passing positive energy, a strong leader definitely builds an efficacious team." - Shahid Maqbool