error in one cell and formula in other

[Guest]

I would like to write a formula referencing two cells that may have this
condition. One cell has an error in it (#num) and the other cell has a
formula in it which meets the condition of making that cell blank. What I
would like to have is an or() statement that if one of these condition the or
statement is true. I have one half of the problem done using iserror() but
can't get the other half.
Thanks

 

[T. Valko]

Try this:

=IF(OR(ISERROR(A1),B1=""),TRUE)

Biff

 

[Guest]

=IF(OR(ISERROR(A1),ISBLANK(B1)),[then],[else])

Dave

 

[Guest]

Hi wolfgangea,

maybe also like this
=OR(ISERROR(C11),D11="")

regards