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?
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?
Re: More than one conditional formula
QuoteIn 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.
Don’t have an account yet? Register yourself now and be a part of our community!