Toolbar Forms & If statements
 

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.

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.

Toolbar Forms & If statements
 

Hi!

Right click the checkbox
Select Format Control
Link the checkbox to a cell. This linked cell will display TRUE when the
checkbox is checked and will display FALSE when the checkbox is unchecked.

Then you can base your formula on the condition of the linked cell:

Linked cell = A1

=IF(A1=TRUE,"X","Y")

Biff

"A.S." wrote in message
...
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.