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