How to Use Division in Excel


Microsoft Excel accepts basic calculation operators such as "+" for addition, "-" for subtraction, "*" for multiplication and "/" for division. There are other scientific operators and formulas accepted in Excel, but those four operators are used for simple arithmetic calculations. Microsoft Excel can divide constant numbers inputted in the cells or it can divide the values based on the cell range or location. This makes Excel flexible for computations because you can put in any number in those cell locations and Excel will compute the results automatically.

Divide Numbers in a Cell

  • Open Microsoft Excel.

  • Click on a cell.

  • Type "=N1/N2" in the cell without the quotation marks, where N1 is the dividend and N2 is the divisor.

  • Press "Enter" to get the result.

Divide Cells in a Range

  • Open Microsoft Excel.

  • Enter a number in one cell. Example, enter 5 in cell A1.

  • Enter a second number in an adjacent cell. Example, enter 10 in cell A2.

  • Type "=Cell1/Cell2" in a blank cell without the quotation marks, where Cell1 is the first cell and Cell2 is the second cell. For example, cell A3 will have the formula "=A1/A2."

  • Press "Enter" to get the results. You can change the values in cells 1 and 2 and the third cell will re-compute the results based on the values of those two.


Promoted By Zergnet


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!