The ISNA function takes one argument,value, which is typically a cell reference.
SeeVLOOKUP without NA errorfor an example.
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
ISEVEN will return the #VALUE error if a value is not numeric.
When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.
ISNONTEXT Function
The Excel ISNONTEXT function returns TRUE when a cell contains any value except text.
This includes numbers, dates, times, errors, and formulas that do not return text.
ISNONTEXT also returns TRUE when a cell is empty.
ISODD will return the #VALUE error if a value is not numeric.
ISREF Function
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not.
it’s possible for you to use the ISREF function to check for a reference in a formula.
