Help with check boxes

Hello,

I am trying to figure out the formula to get a check box to auto check when two other boxes are checked.

In the image attached, I'd like to link the check Boxes in line with Person 1 and Person 2 to the check box in line with President Elect.

How do I do that without linking all the other lines?

Thanks

Find more posts tagged with

Formulas

Cell linking

Comments

Mitch.Shaffer

Use this formula:

=IF(AND(Checkbox3, Checkbox4) = 1, 1)

Place the formula on the President Elect row and update "Checkbox3" and "Checkbox4" to the corresponding cells on the Person 1 and Person 2 rows.

Ann Alexandrowicz

So I just copied that formula into the box and it replied with #UNPARSEABLE

Any Suggestions?

Mitch.Shaffer

Did you replace "Checkbox3" and "Checkbox4" with the cells on the Person 1 and Person 2 row? Checkbox is just a placeholder name that I used because I don't know what your columns are called.

Ann Alexandrowicz

Great got it. Didn't realize I had to change the names.

Thank you!