IF/AND Statement using text & checkbox

Kimberlee Adam

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)

Danielle Arteaga

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.

Danielle Arteaga

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.

Kimberlee Adam

Yah it worked! That was driving nuts, I knew I was just a little off. LOL

Thank you!