# 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