If statement on cell with #N/A

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

[Bondi]

Hi Chris,

Maybe you can use something like:

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

Regards,
Bondi

[Stefi]

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
>
>

[ChrisMattock]

That's perfect guys, thanks.

[Stefi]

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
>
>