Get instant live expert help on what is na

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I would like to add IFError to vlook that all output with NA is shown as 0 instead of #NA
Solved by V. J. in 22 mins
Hi, I have attached a file and below is what I need ... IF total is 0 = NA 1 - 20 = S 21 - 50 = M 51 - 100 = L >=101 - X
Solved by M. C. in 29 mins
=IF([@[Customer Age]]<25,"Youth","NA"),IF([@[Customer Age]]25-34,"Young Adults","NA"),IF([@[Customer Age]]35-64,"Adults","NA"),IF([@[Customer Age]]>64,"Seniors","NA") i am trying to use this formula but i keep getting an error and cant get around it
Solved by G. B. in 28 mins
I am trying to have 3 ranges from one cell (S2) determine the amount I add to another cell (U2) and if it is not any of those 3 ranges to show NA. Not sure which formula to use but this is what I am trying. =COUNTIF(S2<=4>=20,U2+2,[S2<=21>=59,U2+14][S2<=60,U2+30],"NA")
Solved by M. A. in 27 mins
I need help with this vlookup function example that its function returns NA.
Solved by S. Q. in 24 mins