View Single Post
  #3   Report Post  
P Daulton
 
Posts: n/a
Default

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