Division formulas, #DIV/O!
Normally, the results of the formula will update automatically once the data changes.
throw in the number10in cell A3 and pressEnter.
Pointing minimizes potential errors created by typing in the wrong cell reference.
Select cellA2to add that cell reference to the formula after the equal sign.
key in thedivision sign (/) in cell B2 after the cell reference.
Select cellA3to add that cell reference to the formula after the division sign.
The answer (2) appears in cell B2 (20 divided by 10 is equal to 2).
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!
That result can be represented as a percentage by changing the defaultformatting.
