Get instant live expert help on I need help with excel if 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
=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
VLOOKUP in excel my formulas are failing with NA all the time
Solved by E. E. in 27 mins
I am wanting to create a functionality in my excel document that is like the "if, then" function. Anytime the word "YES" or "NA" appears in a particular set of cells, I would like another series of cells to read "NA" or even be blacked out. Is this possible?
Solved by M. Q. in 20 mins
replace #NA to 0 in index match formula if I don't have the data in my index
Solved by I. Y. in 27 mins
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