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!”
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