Combining formulas

Combining formulas

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, [email protected], 1), 1)

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

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


I would appreciate any assistance that you can offer.

Thank you!

Best Answer

Answers

Sign In or Register to comment.