Wednesday 3 May 2017

Excel - The Excel ISNA function

Description


The Excel ISNA function tests if an initial supplied expression (or value) returns the Excel #N/A Error, and if so, returns TRUE; Otherwise the function returns FALSE.
The syntax of the function is:
ISNA( value )
Where the value argument is the expression or value to be tested.

Isna Function Examples

The following spreadsheet shows the Excel Isna function, used to test different values and expressions.
The above examples use different argument types, including:

No comments:

Post a Comment