Thursday, January 14, 2021

ISNA Function in Excel with Example

ISNA ()

This function tests a cell to determine whether it contains the error #N/A.


It will show TRUE for #N/A value in the cell.


Best view in desktop mode.


 

A

B

C

D

1

Values

Result

2

1

FALSE

 =ISNA(A2)

3

Welcome

FALSE

 =ISNA(A3)

4

#VALUE!

FALSE

 =ISNA(A4)

5

14-Jan-21

FALSE

 =ISNA(A5)

6

#N/A

TRUE

 =ISNA(A6)

7

#VALUE!

FALSE

 =ISNA(A7)

8

 

The #N/A is generated when a function cannot work properly because of missing data.


The #N/A can also be typed into a cell by the user to indicate the cell is currently empty but will be used for data entry in the future.


The function is normally used with other functions such as the IF() function.

 



Syntax

=ISNA (Cell)

 

 

 

Formatting

No special formatting is needed.

 

 

 

 

ISEVEN in Excel

<<  Previous

Next  >>

ISNUMBER in Excel

                       

 

 

 


1 comment:

  1. Excel provides numerous formulas for all types of applications, thank you for sharing this. The user guides cover these formulas and their applications, reading these helpful guides can help clear common problems related to Office setup and exploring the features Office offers. Great post.

    ReplyDelete