If statement on cell with #N/A
 

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 if
I do =IF(A1="#N/A","TRUE","FALSE") it doesn't work. Any ideas?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556375

If statement on cell with #N/A
 

Hi Chris,

Maybe you can use something like:

=IF(ISNA(A1),"TRUE","FALSE")

Regards,
Bondi

If statement on cell with #N/A
 

Try =ISNA(A1)

Regards,
Stefi

€žChrisMattock€� ezt Ã*rta:


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 if
I do =IF(A1="#N/A","TRUE","FALSE") it doesn't work. Any ideas?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556375

If statement on cell with #N/A
 

That's perfect guys, thanks.


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556375

If statement on cell with #N/A
 

You are welcome! Thanks for the feedback!
Stefi


€žChrisMattock€� ezt Ã*rta:


That's perfect guys, thanks.


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556375