IF function with #N/A error
 

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.

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

--
Return email address is not as DEEP as it appears
"Roccobarocco" wrote in message
...
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.

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

"Roccobarocco" wrote in message
...
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.

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.

Thanks, guys. Much appreciated.

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