Prev: Run macro on selected sheets
Next: sort range
From: pls123 on 5 Apr 2010 10:44
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
From: Rick Rothstein on 5 Apr 2010 10:51
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" <pls123(a)discussions.microsoft.com> wrote in message
news:0E13B7A5-A512-4A55-A3EA-AA25515A77C8(a)microsoft.com...
> 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

From: Mike H on 5 Apr 2010 10:58
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
From: Ken on 5 Apr 2010 11:01
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 <pls...(a)discussions.microsoft.com> 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

From: JLGWhiz on 5 Apr 2010 11:13
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" <pls123(a)discussions.microsoft.com> wrote in message
news:0E13B7A5-A512-4A55-A3EA-AA25515A77C8(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Run macro on selected sheets
Next: sort range