Function Help Needed

[James]

Greetings;

I have a spreadsheet that I have put a check box on. If the box is
checked (TRUE), I want an function to be performed in another cell. If the
box is unchecked (FALSE), I want the value of the cell to just either be
blank or zero. I used the function dialog box and it took with no errors,
but nothing happens when I check the box. If I type the word 'TRUE' or
'FALSE' in the cell, the function works just fine. However, I want to use
the check box. How do I go about doing this? Many TIA!

James