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.

This Q&A is part of a weekly series of posts highlighting common questions encountered by technophiles and answered by users at Stack Exchange, a free, community-powered network of 80+ Q&A sites.