This tutorial shows you how to fix and remove #DIV/0! error in Microsoft Excel by using the IFERROR or ISERROR function.

If the ERROR.TYPE function in Excel not working for you, ensure the formula is correct, check for errors in the referenced cell, or repair Excel.