Toolbar Forms & If statements
You need to link the check box to a cell, right click on the check box and go
to Format Control, under the "Control" tab you will see a text box named Cell
link: type a cell address preferably one that is hidden or not seen then
refer that cell in your formula.
i.e.
=IF(A1=TRUE,"X","Y")
HTH
JG
"A.S." wrote:
Does anyone know howthis can be done or if this can be done? I am adding a
check box to my spreadsheet (view toolbars forms) Then I am selecting the
box where check marks can be placed. However, how can I tie this into a
formula & cell? In other words, I would like to do it so that if the box is
checked then X otherwise Y. Thanks.
|