NA function - The function returns the # N / A error value in Excel
The following article introduces you to the function NA - 1 of the functions in the information function group is very popular in Excel.
NA function - The function returns the # N / A error value in Excel Picture 1
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:
NA function - The function returns the # N / A error value in Excel Picture 2
- Find the value of the string 'abc' in the data table. In a cell to calculate, enter the formula : = VLOOKUP ("abc", B5: C9,2)
NA function - The function returns the # N / A error value in Excel Picture 3
- Press Enter -> return value is:
NA function - The function returns the # N / A error value in Excel Picture 4
- 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)
NA function - The function returns the # N / A error value in Excel Picture 5
- Press Enter -> return value is:
NA function - The function returns the # N / A error value in Excel Picture 6
- Similarly copying the formula for the remaining values results:
NA function - The function returns the # N / A error value in Excel Picture 7
Above are instructions and some specific examples when using the NA function in Excel.
Good luck!
You should read it
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- How to use the SUM function to calculate totals in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- OR function in Excel, how to use the OR function, and examples
- FORECAST function - The function returns a value along a linear trend in Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- PHI function - The function returns the value of the density function for a normal distribution in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- F.TEST function - The function returns the result of the F - test in Excel
- FISHER function - The function returns the Fissher transformation at x in Excel
May be interested
Guide to familiarize yourself with Excel
How to create the first Workbook in Excel
How to use functions to identify and calculate date information in Excel
STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
STDEVPA function - The function of estimating standard deviations based on an entire population including both text and logical values in Excel
STEYX function - The function returns the standard error of the predicted value of y for each value of x in regression in Excel