Thanks, Roger - I figured out the problem. I had the "thens" switched.

The below is what works:

=IF(OR(C60,D60),E5+C6-D6,"")

"Roger Govier" wrote:

Hi Trudy

There must be something in C or D6.
Try
=IF(OR(ISNUMBER(C6),ISNUMBER(D6)),"",E5+C6+D6)

Regards

Roger Govier


Trudy wrote:
Here is what I tried:

=IF(OR(C60,D60),"",E5+C6+D6)

But the result is the opposite of what I need. E5+C6+D6 is calculating with
nothing in C6 or D6. I don't want it to calculate if either C6 or D6 are
empty.

Thank you, Roger.

"Roger Govier" wrote:


Hi Trudy

Something like
=IF(OR(A10,A20),"",B1+B2)

Regards

Roger Govier


Trudy wrote:

How do I accomplish this:
If a cell value 0 OR another cell value 0, then leave blank. If either
contains a value, then calculate.