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

tj

"Roccobarocco" wrote:

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.