Forum Discussion
IF, OR, AND Formulas
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.
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.
- Thank you so much for your help. This worked perfectly. I think I was making it more difficult than it needed to be. Long work day yesterday.
Clarue Glad to help you please keep asking ☺
