IF for inverting true/false

  • Thread starter Thread starter pls123
  • Start date Start date
P

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
 
Just use the NOT function on your original expression...

=NOT(OR(AND(T65-U65>=Q55*N11;L10=TRUE);(U55*Q56<=T55)))
 
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.
 
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
 
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.
 
Back
Top