Divide in Microsoft Excel  Step by Step Guide ▷ 2020

Microsoft Excel is a tool with multiple functions to manage finances in an environment domestic or business. The software allows Solve mathematical problems quickly and easily as well how to split cell data automatically.

Additions, subtractions, multiplications and divisions are possible in Excel. No need to resort to a calculator. With only specify cells corresponding with a simple formula, the operation I know will resolve immediately.

You can make a division On any cell, row or column and the results they will be very successful. Do you want to know how to split cell data in Excel?. Keep reading, as we present you a step-by-step guide.

What are the best formulas to divide anything in Excel?

What are the best formulas to divide anything in Excel?

All mathematical formula included in Excel should start with a sign of “Equal” (=). On the other hand, the divisions are characterized by using the division operator (/). For example, a division into Excel is expressed as “same”, followed by the “numerator”, accompanied by the “operator” and culminates in the “denominator” (= 20/2). To obtain the result, it is only necessary to press the key “Enter”.

There are two methods to perform a division in Excel. First of all, you can enter the complete formula in any cell. Either by clicking and typing on the same grid, or use the formula bar on the ribbon. These are the best formulas to divide anything in Excel.

For example, with the first method Try introducing the following mathematical problem: = 20/2 By pressing the key “Enter”, the result will appear above the cell that you have previously selected.

The second method, implies the possibility of perform the mathematical operation with a numerator and denominator located in different parts of the spreadsheet. They can be in a row, column, or multiple cells at once.

For example, let’s say the number 20 is in the cell B4, Meanwhile he number two (2) is in the cell G6. All you have to do is enter division formula on any other grid. click about C8, or about a cell of your preference.

Enter the sign “Equal” (=) followed by the position of the numerator (B4), then the division operator (/) and culminates with the location of the denominator (G6), that is to say, (= B4 / G6) to perform the mathematical operation, proceed to press “Enter”. The difference between both formulas is that, in the first method, the result happens to occupy the cell where the formula was entered, so the values ​​disappear. While the second method, preserves the numerator and denominator values.

Similarly, when it comes to split multiple figures into columns or rows for one between the same number, it is necessary to add the sign “$” in the formula, to specify that the number is absolute for all cells. If the absolute number is in C2, you must divide it with the first value of the row or column. Thus, the formula is expressed like this: = B2 $ C $ 2.

Steps to perform a division in Microsoft Excel automatically

Steps to perform a division in Microsoft Excel

Perform mathematical operations in excel it’s not complicated. The formulas are easy to learn and you only need to open one new spreadsheet.

Next, we are going to show you the steps to perform a division in Microsoft Excel automatically:

Data

Dividing data in Excel is quite simple, you just have to enter a formula on any cell:

  • Position yourself on a cell of your preference. For example B2.
  • Let’s say you want to know how much 20 is between 2. To do this, proceed to enter the following formula: = 20/2.
  • Press the key “Enter”. The result will appear in the box B2.

Cells

The process it is similar to the previous one. The difference is in the location of the values.

The steps to follow to divide into cells are the following:

  • Enter the numerator in a box. For example, B2.
  • Enter the denominator in a continuous box. For example, C2.
  • In the next cell, D2, enter the division formula. Only instead of entering the numbers, you should add the locations, that is: = B2 / C2.
  • Press “Enter” on the keyboard to perform division. The result will appear in cell D2, without modifying the grids B2 and C2.

Columns

In Excel it is also possible split multiple cells in a column to get a total result.

Starts with:

  • Enter the entries in a column of your choice. For example, let’s say the numbers are contained from the cell B2 through B20, and you want split all grids by the same number located in C2.
  • Click on any other cell. For example, D2. Now proceed to Enterokay the following formula: = B2 / $ C $ 2.
  • The result will appear in cell D2. In the lower right corner of cell, you will find a small square.
  • Click on the box and drag it to the box D20 for the formula to apply to the rest of the values ​​of column B2 to B20.

Rows

The operation it is executed in the same way as the previous procedure. Except that, instead of a column, it is done with a row.

Let’s see how to do it:

  • Enter the entries in a row of your choice. For example, in the row 4 from the column B. (B4, C4, D4, E4, F4, G4)
  • In row 5 (B5) enter the number by which the entries should be divided.
  • Click on the next row (B6) and proceed to enter the formula: = B4 / $ B $ 5
  • By pressing “Enter”, the result will appear in cell B6.
  • Now, select the grid again B6 and press the lower right corner, on a black square.
  • Drag the square to the right, up to box G6. In this way, all values ​​will be divided between value of B5.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment