Nested IF with OR Function
 

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.

Nested IF with OR Function
 

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.

Nested IF with OR Function
 

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.

Nested IF with OR Function
 

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.

Nested IF with OR Function
 

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.

Nested IF with OR Function
 

Hi Trudy
Glad you got it sorted.
As I drove off to the pub, I suddenly thought it was quite illogical.
Why would you be wanting to add/subtract C6 and D6 if they were 0, but in
the haste of answering, I didn't consider the facts.
It's amazing how the thought of alcohol brings out the true logic<bg

Regards

Roger Govier


Trudy wrote:
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.