Description
The ISNUMBER function is a conditional function that returns either TRUE or FALSE as result. Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results based if the particular scenario changes.
#N/A error is returned by Excel if there is a missing value in the syntax of a function.
In the ISNA function, if the referred cell contains #N/A error, it means the condition is met and the TRUE result will be returned.
=ISNA(value)
The ISNA function’s syntax has the following argument:
- ISNA Required
The value is the cell reference that you want to test against the condition if the cell contains #NA error. The value argument can be a blank (empty cell), error, logical value, number, text or reference value, etc.
