3 value if sentence

[piiska]

Hi.

I am facing troubles when I'm trying to get TRUE or FALSE with these values:

value A: 50
value B: 100
value C: 150

So value should be TRUE if A and B are smaller than C. And FALSE if A is smaller than C but B is greater than C.

Would someone more experienced tell me right formula to do such calculation?

[Fotis1991]

Try

=IF(AND(A1<C1,B1<C1),TRUE,IF(AND(A1<C1,B1>C1),FALSE))

[rcm]

suppose

cell A1 50
cell A2 100
cell A3 150


=if(and(a1<a3,a2<a3),"TRUE","FALSE")

this is FALSE also when A1>A3 and A2<A3

[piiska]

It's working! Sorry fotis, i didn't read your autofilled text first. :P TY!

[piiska]

Now another problem.

It should now be TRUE if A and B values are BOTH smaller or greater than C. and FALSE if only A or B is greater than C. Hope you understood what I am after.

[piiska]

Is that formula even possible?

[Fotis1991]

Try

=IF(OR(AND(A1<=C1,B1<=C1),AND(A1>C1,B1>C1)),TRUE,IF(OR(A1>C1,B1>C1),FALSE))

[dredwolf]

You can shorten Fotis' solution to this even:
=IF(OR(AND(A1<=C1,B1<=C1),AND(A1>C1,B1>C1)),TRUE,FALSE)

as that if the first portion is False, then only 1 of the values is larger than C1

Hope this helps