More than one conditional formula

Philosophaie · Feb 5th 2017

How do I program more than one conditional formula?

In Cells:
B11=35
B12=25
B13=45
=IF(B11>=B12 & B12<=B13,"T","F")
Answer:
F
it should be "T"

In Cells:
B16=1
B17=2
=IF((B16<>B17 AND B16<B17),"TRUE","FALSE")
Answer:
#NAME?

BaraaKhalil · Feb 5th 2017

Re: More than one conditional formula

Use AND at first

Code

=AND(B11>=B12,B12<=B13)

Code

=AND(B16<>B17,B16<B17)

AAE · Feb 6th 2017

Re: More than one conditional formula

Quote

In Cells:
B16=1
B17=2
=IF((B16<>B17 AND B16<B17),"TRUE","FALSE")
Answer:
#NAME?

All you need is: IF(B16<B17,TRUE,FALSE)

If B16 is less than B17 then it is always going to be "not equal to", thus you only need to test for the one condition.

Participate now!