View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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