If statement on cell with #N/A

  • Thread starter Thread starter ChrisMattock
  • Start date Start date
C

ChrisMattock

I have a cell that returns a value #N/A if information is not available
I need to do an If statement to see if this cell has #N/A in it, but i
I do =IF(A1="#N/A","TRUE","FALSE") it doesn't work. Any ideas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#N/A In Cells 7
Handling Dashes in IF statement 3
Scrabble Value calculation for Welsh words 0
Nesting IF/OR Statement 14
Help With VLOOKUP 2
Removing #N/A from an "If/Then" statement 4
MATCH not working in IF statement 6
IF(AND with date comparison 4

Back
Top