Finding Errors

Sometimes when you enter a formula an error will occur. This is to indicate that the formula syntax is incorrect.
If this error occurs press OK to be taken back to the formula bar. You can either correct the formula or press ESC to remove the formula completely.
This error may be caused by missing parentheses or incorrect arguments being passed to functions (e.g. passing a string when it is expecting a number).
To quickly locate any cells that contain errors, select (Home tab, Find & Select > GoTo Special) and tick the Formulas, Errors checkbox.


Error Checking Dialog Box


Error Tracer Arrows

These are red



© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext