NA function. Generate N/A error.(Microsoft Excel)

Japanese version.

This function generates a #N/A error.

The #N/A error occurs when a search fails in the VLOOKUP or XLOOKUP function.

How it works

=NA()

Example Results

Currently, this function has very limited use, such as when you want to generate an error as a result of an IF function.

---

Links

Microsoft Excel Functions Information