This article explains how to divide in Excel using a formula. Instructions apply to Excel 2016, 2013, 2010, Excel for Mac, Excel for Android, and Excel Online.

Here are some key points to remember about Excel formulas:

Although it is possible to enter numbers directly into a formula, it is better to enter the data into worksheet cells and then use cell references, as demonstrated in the example below. That way, if you need to change the data, it is a matter of replacing the data in the cells rather than rewriting the formula. Normally, the results of the formula will be updated automatically as the data changes.

Let's create a formula in cell B2 that divides the data in cell A2 by the data in A3.