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.