Forum Discussion
Solved
Combining IF, AND and OR statements
I am trying to combine these two formulas together =IF(AND(A1="vacant",B1="c"),1,0) and =IF(AND(A1="vacant",B1="d"),1,0).
Basically what I want is IF A1 is vacant position and B1 is D or C, true. If not false.
I am not well versed in formulas and all the research I've done and try to implement gives me an error return.
| staffed | D |
| vacant | C |
| vacant | D |
| staffed | C |
| vacant | C |
| staffed | D |
=AND(A1="vacant", OR(B1={"C", "D"}))
or if you prefer
=IF(AND(A1="vacant", OR(B1={"C", "D"})), 1, 0)
or even
=(A1="vacant")*OR(B1={"C", "D"})
=AND(A1="vacant", OR(B1={"C", "D"}))
or if you prefer
=IF(AND(A1="vacant", OR(B1={"C", "D"})), 1, 0)
or even
=(A1="vacant")*OR(B1={"C", "D"})
- Thank you Hans, I used =IF(AND(A1="vacant", OR(B1={"C", "D"})), 1, 0) and it works. I appreciate the help!
