IF, OR, AND Formulas

Clarue 

Yes it's possible to use AND and OR together but what you are trying doesn't needs AND & OR together, since in A2 you are testing two different values. 

Like if A2="At Once" AND D2>B2 should 

If(and(A2>"At Once",D2>B2),F2,0)

Another is 

IF(and(A2="Future", C2>B2),F2,0)

But in both cases you are getting F2 then it should like,,

=IF(AND(A2="At Once",D2>B2),F2,IF(AND(A2="Future",C2>B2),F2,0))

Or you may write this:

=IF(OR(A$2="At Once",A$2="Future"),IF(OR(D$2>B$2,C$2>B$20),F$2,0),0)

• You may adjust cell references in the formula as needed.