User Profile
Zuceth
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 DSolved524Views0likes2Comments
Recent Blog Articles
No content to show