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.
Most information (good and bad) will stay on your credit report for seven years. However, some financial disasters (divorce, bankruptcy) can stay for as long as ten years. The â¦ silver lining to this is that, the older the negative information is, the less influence it has on the overall report. The seven year statute of limitations on information listed on your credit report figures from the date of last activity. 2  According to the FCR Act Section 605 a debt can remain on a credit report for 7 years and 180 days after the delinquency that caused the account to go bad.