ISNA function - The function returns True if the value is an # N / A error value in Excel

The following article introduces you to the ISNA function - one of the functions in the information function group is very popular in Excel.

ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 1

Description: The function returns True if the value is an # N / A error value in Excel.

Syntax: ISNA (value)

Inside:

- value: The value you want to test is a # N / A error value , is a required parameter.

Attention:

- The function returns True if the value is an # N / A error value and vice versa returns a False value .

For example:

Determine where the values in the value are # N / A error values .

ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 2

- In the cell to calculate enter the formula : = ISNA (C6)

ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 3

- Press Enter -> return value is:

ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 4

- Here, cell value C6 is not an # N / A error value, so the function returns False.

- Similarly copying the formula for the remaining values results:

ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 5

- There is only error # N / A, the function returns True value , the rest of other error values return false.

Above are instructions and some specific examples when using the ISNA function in Excel.

Good luck!

Micah Soto

Update 19 May 2020

You should read it

May be interested

ISNUMBER function - The function returns True if the value is numeric in Excel
isnumber function: the function returns true if the value is numeric. use the function to check if the value is numeric or not. syntax: isnumber (value)
ISEVEN function - Function returns True value if the value is even in Excel
iseven function: the function returns true if the value is even in excel. syntax: iseven (value)
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
ISLOGICAL function - The function returns True if the value is a logical value in Excel
islogical function: the function returns true if that value is a logical value in excel. syntax: islogical (value)
CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
error.type function: the function returns the number corresponding to one of the error values in microsoft excel, or the # n / a error if there are no errors. syntax: error.type (error_val)
F.TEST function - The function returns the result of the F - test in Excel
f.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
Any () function in Python
in python, any () function returns true if any element of an iterable is true. if no true element is present, any () function will return false.
POISSON.DIST function - The function returns the Poisson distribution in Excel
poisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)