View Single Post
  #1   Report Post  
Roccobarocco
 
Posts: n/a
Default 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.