ISNA Function for "Not Available" Excel Data
Data not available creates ugly error messages when we use functions in MS Excel tables.
For example, in the below table:
logical yes option." In our formula, the logical yes value is the result of the VLOOKUP calculation. ” width=”485″ height=”261″ />
#N/A means the functions embedded into Bonus cells cannot find what they need to find to calculate the value appropriately.
You can publish any numeric or text value you like in such cases by using the ISNA function, which asks “is what follows not available?”
Here, the formula in cell C5 says:
- “If the value in this cell is not available, then print “Missing Data.”
- “If that is not the case, that is, if there is data available in this cell, then print the logical yes option.”
In our formula, the logical yes value is the result of the VLOOKUP calculation.