Whatever cell the checkbox is linked to can be used in your IF statement.

If the checkbox is tied to say cell a1, in another cell if you put
"=if(a1=true,"Happy","Sad")" (without quotes) as you check and uncheck the
box the other cell will change from Happy to Sad.

Squeaky

"jvatlanta" wrote:

Can anyone give an example of accessing the logic state of a form-checkbox
(true-false) for use in an IF statement?