IF/AND Statement using text & checkbox
Ok, I've got to be so close on this formula and it's probably something so simple I'm missing.
I want the cell to check the box if two criterion are met: The "In AOP" is checked, and the Status is "Temporary Replacement".
=IF(AND(FIND([Employment Status]@row, "Temporary Replacement), FIND([In AOP]@row, =1), 1, 0)
Best Answer
-
I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column.
If that's true, this should do it:
=IF(AND([Employment Status]@row = "Temporary Replacement", [In AOP]@row = 1), 1, 0)
Not sure why you're using "FIND." Are you trying to get a summary of ALL rows that have both "Temporary Replacement" and the In AOP box checked? If so, you could create a column that uses the formula I provided, then use the worksheet summary flyout to place a COUNTIF formula for that summary.
Answers
-
I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column.
If that's true, this should do it:
=IF(AND([Employment Status]@row = "Temporary Replacement", [In AOP]@row = 1), 1, 0)
Not sure why you're using "FIND." Are you trying to get a summary of ALL rows that have both "Temporary Replacement" and the In AOP box checked? If so, you could create a column that uses the formula I provided, then use the worksheet summary flyout to place a COUNTIF formula for that summary.
-
Yah it worked! That was driving nuts, I knew I was just a little off. LOL
Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!