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.