Combining formulas

Tina

Hi,

I need some help with a formula. I have a one check mark column that I would like to 'check' if any of the following formulas are true. Can I combine them into one large formula?

=IF(AND([Key Activity]@row, 1, [CEC Tech]@row, 1), 1)

=IF(AND([Key Activity]@row, 1, [Corp iT]@row, 1), 1)

=IF(AND([Key Activity]@row, 1, Digital@row, 1), 1)

=IF(AND([Key Activity]@row, 1, Loyalty@row, 1), 1)

=IF(AND([Key Activity]@row, 1, [L+D]@row, 1), 1)

I would appreciate any assistance that you can offer.

Thank you!

L_123

=if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,Digital@row,Loyalty@row,[L+D]@row),1

I think that should do it. you might be able to get it shorter depending on how the sheet is organized, but I can't tell without seeing the sheet. If you want to try you can post a picture of the sheet blurring out any personal info and I would be happy to try.

L_123

=if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,Digital@row,Loyalty@row,[L+D]@row),1

I think that should do it. you might be able to get it shorter depending on how the sheet is organized, but I can't tell without seeing the sheet. If you want to try you can post a picture of the sheet blurring out any personal info and I would be happy to try.

Tina

Thank you! It works perfectly.