SUMMARY. When you divide by 0 (zero) or a blank cell, Microsoft Excel displays the error value #DIV/0! as the result of the calculation.This article shows you how to use the IF worksheet function to suppress the #DIV/0! error value.ell A3 will appear blank if cell A2 is blank or contains a zero. Otherwise, A3 will contain the result of the expression A1/A2. To display other information in the cell if the divisor is blank or zero, type the necessary information in the formula where the  (quotation marks) appear.
Medical Collections After 7 Years. Medical collections are reported to credit bureaus most frequently by collections agencies. These data are reported as derogatory items, and must age off your file after seven years from the date the account was deemed delinquent.
How long it stays on your credit report: Although a DRO typically lasts a year, it will stay on your credit report for six years from the date the arrangement starts.Defaulted debt.ow long it stays on your credit report: Although a DRO typically lasts a year, it will stay on your credit report for six years from the date the arrangement starts. Defaulted debt.