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
|