The following article introduces you to the function NA - 1 of the functions in the information function group is very popular in Excel.
Description: The function returns the N / A error value, which means that no values match the search results.
Syntax: NA ()
- The NA () function contains no arguments.
Attention:
- Must enclose parentheses in the function name.
- You can enter the value # N / A immediately in the cell to mark the blank value.
For example:
Determining the return value of the MATCH and VLOOKUP functions is described in the following data table:
- Find the value of the string 'abc' in the data table. In a cell to calculate, enter the formula : = VLOOKUP ("abc", B5: C9,2)
- Press Enter -> return value is:
- The string 'abc' is not in the data table -> the function returns the # N / A error value .
- Similar to the MATCH function -> enter the formula: = MATCH ("1234", B5: C10,0)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
Above are instructions and some specific examples when using the NA function in Excel.
Good luck!