IF function with #N/A error

[Roccobarocco]

Does anyone know if it is possible to use the IF function with a cell
containing the #N/A error?

Specifically, I want to do something on the following lines:

=IF(A3=#N/A,B3,C3)

because the error in A3 is sometimes expected.

 

[Jack Sheet]

=IF(ISNA(A3),B3,C3)

 

[P Daulton]

=IF(ISNA(A3),B3,C3)

 

[tjtjjtjt]

Try:
=IF(ISNA(A3),B3,C3)

tj

 

[Roccobarocco]

Thanks, guys. Much appreciated.