Checkbox Range Formula

hennarizvi

Hello-

 

Is there a formula that will check a box if another range of cells is also all checked?

 For example, I have a column that has 5 checkboxes in it.  I want another cell to also check off as soon as all 5 checkboxes in the column have been checked.

 

Nic Larsen

You can use something like this although there is probably a cleaner way to do the formula:

=IF(AND([Check Box]1 = 1, [Check Box]2 = 1, [Check Box]3 = 1, [Check Box]4 = 1, [Check Box]5 = 1), 1, 0)