Get instant live expert help on na or n/a

“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 need Column L to state either Yes, No, or NA Yes if same number and same or less letters No if Same number with at least one same letter but more letters N/A if H3 = E3 Otherwise blank More details are provided in the sheet
Solved by S. C. in 20 mins
Hi! I'm trying to create a COUNTIF formula that will count the "yes" in the column and also subtract n/a or not applicables from the denominator and divide the number of "yes" by the total number. For example COUNTIF(H2:H115"yes")/na-115)
Solved by F. L. in 16 mins
I am trying to do a VLOOKUP. It keeps resulting in NA or #REF!
Solved by A. J. in 22 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
=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