You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that must be dealt with. This is especially relevant when further calculations are based on cells containing an error. Excel’s ISERROR() function returns TRUE if it detects any of the Excel error codes — the ISNA() function does the same but only if the #N/A error code is returned.

In this tutorial:
  1. Syntax
  2. Example
See also:
  • ISERR()
  • ISERROR()
  • IFERROR()
  • IFNA()
  • ERROR.TYPE()

1. Syntax

=ISNA(expression, value_if_na)

expression is any valid expression (formula, function, etc.)

value_if_na is a text string displayed in place of #N/A

Returns the result of the expression if it is available, or the text string in value_if_na if the #N/A is returned.

2. Example

Head on over to the VLOOKUP() function tutorial.


References:

  1. Microsoft Support. (no date) IFNA function. Available at: https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 (Accessed: 16 April 2024).

By MisterFoxOnline

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.