Multiple Check Boxes

[Brenda42]

Hello Everyone

I'm struggling to effectively learn to use multiple check boxes. I understand how to link the check box to a cell, and in this case, I can make B1="NO-GO" if only 1 box is checked. The problem is how to combine two check boxes.

If only one checkbox is checked, B1="NO-GO"
If both are checked, B1="GO"

As always, thank you for all the wonderful help.

Brenda

[BarryTSL]

Can you just use an If statement?
If one cell is true say No go, if both cells are true say Go.

[Brenda42]

I can, as a matter of fact I've tried to write it several ways, all have failed. I can make it work with one, but not using both check boxes.

Brenda

[Brenda42]

Thanks everyone, I either got lucky, or maybe I'm getting smarter. I'll call this one solved.

Brenda