Logical Function - IFERROR

An essential function for dealing with misplaced error messages (i.e. anything that starts with a #). IFERROR tidies things up and can be added retrospectively to any existing function.

The video shows the IFERROR function in use.

The final written calculation is below:

=IFERROR(C3/$C$7,"Enter Data")

In this formula, C3/$C$7 calculates the percentage of individuals who answered 'very good' to our questionnaire.

The "Enter Data" part tells Excel what to display if the answer to C3/$C$7 is an error message.