IF for inverting true/false

[pls123]

hello all !!
i have this....
=OR(AND(T65-U65>=Q55*N11;L10=TRUE);(U55*Q56<=T55))

but for some formal reason i need it to give false when it's true and vice
versa..
with this... if i am not wrong...
=IF(OR(AND(T65-U65>=Q55*N11;L10=TRUE);(U55*Q56<=T55));FALSE;TRUE)

am i right ?? tx !!
paolo

 

[Rick Rothstein]

Just use the NOT function on your original expression...

=NOT(OR(AND(T65-U65>=Q55*N11;L10=TRUE);(U55*Q56<=T55)))

 

[Mike H]

hi,

Try this

=NOT(OR(AND(T65-U65>=Q55*N11,L10=TRUE),(U55*Q56<=T55)))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Ken]

Paolo

I think what you did should work.
If you just want it to be the opposite of the original formula, you
could probably simplify it with NOT.

Maybe

=NOT(OR(AND(x,y),z))

where x, y, and z are the three things you check.

Ken

 

[JLGWhiz]

Logical Arguments 1 and 2 equate to true thereby making the resulting answer
= False.
You can check this by clicking on the formula wizard nest to the display
window in the formula bar.