IF for inverting true/false
 

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

IF for inverting true/false
 

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

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

--
Rick (MVP - Excel)



"pls123" wrote in message
...
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

IF for inverting true/false
 

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.


"pls123" wrote:

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

IF for inverting true/false
 

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

On Apr 5, 10:44*am, pls123 wrote:
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

IF for inverting true/false
 

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.


"pls123" wrote in message
...
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