How to Multiply & Divide in Microsoft Excel?

Microsoft excel is a widely used platform launched by Microsoft among its various Microsoft Suites. It is a worksheet or spreadsheet which finds applications for various operations, such as graphical representation, pivot tables, pie charts, and arithmetic calculations. It features a macro programming language for Visual Basic for Applications.

Now this article gives mostly the emphasis on certain arithmetic operations that is Multiplication and Division. The most indispensible features of Excel is its spectacular calculation codes implemented by VBA for various kinds of Mathematical Computations.

Don’t miss: How to Recover Forgotten MS Excel Password

Methods: How to Multiply and Divide in Excel?

Method 1: Multiplication using Two or More Cells

This method is somewhat a shortcut to the laborious process of multiplying numbers using Excel.

Step 1.Go to your "Start" icon in your Windows and type "Microsoft Excel" and hit "Enter".

Step 2.Once the Excel opens up; choose any particular blank cell where you want to do your multiplication by clicking on it.

Step 3.Now type "=" equal sign to start a formula.

NOTE: In Microsoft Excel all the formulas are initiated with the symbol of equal sign "=".

Step 4.After typing the equal sign "=", enter the numbers that you want to multiply, just put asterisk sign "*" separating all the numbers. The asterisk sign is usually a representation of multiplication in digital computations.

For instance: "=5*5*4"

multiply divide in excel

Step 5.Hit "Enter" after you have finished entering the numbers for multiplication.

Step 6.On hitting "Enter", the result would come out in the cell that you selected in the first place.

For the above mentioned example the answer would appear in the cell as: 100

Method 2: How to Multiply Large Numbers Using Cell References

Cell reference implements the representation of rows and columns while performing your operations. The advantage of using cell reference is that you can change the cell value without needing to change the formula altogether.

Step 1.Type the numbers you want to multiply in cells D1 and E1.

For example: 5 in D1 & 4 in E1

divide in excel

Step 2.Click on the cell F1 and select it.

Step 3.In F1 cell, type "=" sign to start a formula.

Step 4.Once you are done with this much, type the cell numbers D1, E1 followed by the equal sign and asterisk sign in between. You can also click on the D1, E1 cells to bring the values in the F1 cell.

For example: =D1*E1

multiply in MS excel

Step 5.Press "Enter’ to get the result.

Step 6.In the F1 cell the result would appear up as 20.

how to multiply in excel

Method 3: How to Divide Two Numbers in One Cell

The operation of division is quite similar to that of multiplication. The difference only lies in the operator being used.

Step 1.Click on any blank cell and enter "=" to start any formula.

Step 2.Once you are done with it, type any two numbers that you want to divide, separated by a forward slash "/" symbol.

For example: =54/2

Divide Two Numbers in One Cell

Step 3.Once you have completed formulating in the exact pattern hit "Enter".

Step 4.On hitting "Enter", the answer of division would appear on the selected cell.

Step 5.For the above example the answer would come out as 27.

how to Divide Two Numbers in One Cell of Excel

Method 4: Division of Numbers using Cell References

The following method is just the same as the one used for multiplication operation, the difference only lies in the operator that is being used. The operator used here is forward slash "/".

The cell reference allows you to change the value without having to change the entire formula.

Step 1.Enter a number 60 in a cell A1 and another number 12 in a cell B1.

Division of Numbers

Step 2.In a blank cell C1, enter equal sign "=" to start the formula for excel.

Step 3.Once you are done with the formula initialization, type the cell numbers A1/B1.

NOTE: You can bring down the cell numbers by clicking on them.

Division of Numbers in excel

Step 4.After you have finished up the formulation in the excel spreadsheet, press "Enter".

Step 5.On hitting "Enter", the answer would automatically appear in the C1 cell.

Step 6.As per the above example, the answer would turn up as 5.

learn Division of Numbers

Conclusion:

As you can already see that Excel cannot only accelerate the rate of computation but does the computation in a very well organized manner. Thus the user using it for the first time would find it very convenient and user friendly afterwards by exploring its many other features.

The above article has been demonstrated with a very guideline in such a way that anybody can discern easily the approach required for doing such calculations, so if you need to multiply numbers in excel or divide two numbers in One Cell.  Just follow the steps in this article.

For more information, go to our website and subscribe.

Related articles:

  1. How to Insert Date & Time in Microsoft Excel Spreadsheet
  2. How to Unlock A Password-Protected MS Word Document