Question

Name the error which occurs when a given number is divided by zero; e.g. 7/0. What are the reasons for this error? How can this error be corrected?

Accepted Answer

The error will be correct a DIV/0! Error. This error occurs when a number is divided by zero(0). Reasons: (a) Entering a formula that contains explicit division by zero(0). (b) Using cell reference to a blank cell or to a cell that contains zero as a divisor. Solutions: • Change the cell reference to another cell. • Enter a value other than zero in the cell used as a divisor. • Enter the value N/A into the cell referenced as the divisor, which changes the result of the formula, to N/A from DIV/0! To denote that the divisor value is not available. • Prevent the error value from displaying by using the IF worksheet function.

Marking-scheme solution

More from Spreadsheet