Question: formula to check if checkbox is checked?
Answer: After inserting the check box (Form Control), select it and link it to a specified cell C2 by entering =C2 into the Formula Bar. ...  Select the lined cell (C2), then enter formula =IF(A2="Test",TRUE,FALSE) into the Formula Bar, and then press the Enter key.