Question on Logical IF statement
 

Is it possible to have a "IF, Then" formula for the scenario where you have
3 variables such as:

If A OR B is true AND C is False then 8 otherwise 0.

Either A or B can be true, but C must always be true for the formula to
return 8, otherwise it would return 0.

My specific formula is
=IF(G32=R10,0,IF(OR(C32<C7,C32C8),IF(AND(R32=FALS E),R10,0))) The result I
get is FALSE. I am looking for the value in R10 which is 8 or 0 (that is
zero). In this case I was expecting a zero. How do I write an If ORAnd
combination?

Any ideas?

Question on Logical IF statement
 

=IF(Or(G32=R10,R32=False),0,IF(OR(C32<C7,C32C8),R 10,0))

--
Regards,
Tom Ogilvy


"TimN" wrote:

Is it possible to have a "IF, Then" formula for the scenario where you have
3 variables such as:

If A OR B is true AND C is False then 8 otherwise 0.

Either A or B can be true, but C must always be true for the formula to
return 8, otherwise it would return 0.

My specific formula is
=IF(G32=R10,0,IF(OR(C32<C7,C32C8),IF(AND(R32=FALS E),R10,0))) The result I
get is FALSE. I am looking for the value in R10 which is 8 or 0 (that is
zero). In this case I was expecting a zero. How do I write an If ORAnd
combination?

Any ideas?

Question on Logical IF statement
 

You were close, but the logic of the "or/and" part is wrong. Try this:

=IF(G32=R10,0,IF(AND(R32=FALSE,OR(C32<C7,C32C8))= TRUE,R10,0))

The OR has to be a condition in the AND to do what you're talking
about...


TimN wrote:
Is it possible to have a "IF, Then" formula for the scenario where you have
3 variables such as:

If A OR B is true AND C is False then 8 otherwise 0.

Either A or B can be true, but C must always be true for the formula to
return 8, otherwise it would return 0.

My specific formula is
=IF(G32=R10,0,IF(OR(C32<C7,C32C8),IF(AND(R32=FALS E),R10,0))) The result I
get is FALSE. I am looking for the value in R10 which is 8 or 0 (that is
zero). In this case I was expecting a zero. How do I write an If ORAnd
combination?

Any ideas?