How to divide cells in Excel (using references)
As you know, you can input values in the cells of your worksheet.
So when you divide in Excel, you can just click the cell that contains the numbers you want to divide and divide by 😀
For example, if you want to divide 10 by 2, you can click the cell references that contain these numbers.
You can find the cell reference in the name box found to the left of the formula bar.
Let’s try it 💪
Let’s divide 10 by 2 again but this time using cell references.
- Double-click an empty cell and type the equal sign (=) to start the formula.
- Instead of typing 10, click the cell reference which has a cell value of 10.
In our example, it’s cell B3.
Then type the forward slash (/) arithmetic operator.
- Next, instead of typing 2, click the cell reference which has a cell value of 2.
In our example, it’s cell B5.
Excel shows you the quotient of the formula which is 5 👍
Below are other examples of how to divide in Excel using cell references.
If you divide a number by 0 or select an empty cell reference, Excel displays the #DIV/0! error.
So, make sure you click the cell references correctly when you divide numbers.
With the use of cell references, you’re not typing numbers directly in the cell.
This is super helpful especially when you have data already entered into the cells of the worksheet.
Easy, right? 😊