Under Formulas there is an option Error Checking, try using it, has sorted lot of problems for me.