| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
