Division in Excel
Here are some important points to remember about Excel formulas:
Formulas begin with the equal sign ( = ). The equal sign goes in the cell where you want the answer to display. The division symbol is the forward slash ( / ). The formula is completed by pressing the Enter key on the keyboard.
Use Cell References in Formulas
Although it is possible to enter numbers directly into a formula, it’s better to enter the data into worksheet cells and then use cell references as demonstrated in the example below. That way, if it becomes necessary to change the data, it is a simple matter of replacing the data in the cells rather than rewriting the formula. Normally, the results of the formula will update automatically once the data changes.
Example Division Formula Example
Let’s create a formula in cell B2 that divides the data in cell A2 by the data in A3. The finished formula in cell B2 will be:
Enter the Data
Enter the Formula Using Pointing
Although it is possible to type the formula (=A2/A3) into cell B2 and have the correct answer display in that cell, it’s preferable to use pointing to add the cell references to formulas. Pointing minimizes potential errors created by typing in the wrong cell reference. Pointing simply means selecting the cell containing the data with the mouse pointer (or your finger if you’re using Excel for Android) to add cell references to a formula. To enter the formula: The answer (2) appears in cell B2 (20 divided by 10 is equal to 2). Even though the answer is seen in cell B2, selecting that cell displays the formula =A2/A3 in the formula bar above the worksheet.
Change the Formula Data
To test the value of using cell references in a formula, change the number in cell A3 from 10 to 5 and press Enter. The answer in cell B2 automatically changes 4 to reflect the change in cell A3.
#DIV/O! Formula Errors
The most common error associated with division operations in Excel is the #DIV/O! error value. This error displays when the denominator in the division formula is equal to zero, which is not allowed in ordinary arithmetic. You may see this error if an incorrect cell reference was entered into a formula, or if a formula was copied to another location using the fill handle.
Calculate Percentages With Division Formulas
A percentage is a fraction or decimal that is calculated by dividing the numerator by the denominator and multiplying the result by 100. The general form of the equation is: When the result, or quotient, of a division operation is less than one, Excel represents it as a decimal. That result can be represented as a percentage by changing the default formatting.
Create More Complex Formulas
To expand formulas to include additional operations such as multiplication, continue adding the correct mathematical operator followed by the cell reference containing the new data. Before mixing different mathematical operations together, it is important to understand the order of operations that Excel follows when evaluating a formula.
