Seach BOX

analytics

Get cell value as #NA - Excel Function NA()

You must be wondering that every time I try my best to avoid #NA in excel sheet but why is this post talking about getting #NA as output. Well #NA is very important at many instances and very useful in charts. We will discuss that later. 

Function to get #NA is

.
NA( )
.
I.e.
.

If(B1=0,NA())
.
Then whenever value of B1 cell is Zero then output of formula will be #NA

No comments:

Post a Comment

Your comments are important for us.