Question on Logical IF statement

[Guest]

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,C32>C8),IF(AND(R32=FALSE),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 >>>OR>>>And
combination?

Any ideas?

 

[Guest]

=IF(Or(G32=R10,R32=False),0,IF(OR(C32<C7,C32>C8),R10,0))

 

[crferguson]

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,C32>C8))=TRUE,R10,0))

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