Calc: If/Then with Checkbox

Is there a way for me to perform an if/then in Calc (v5) based on whether or not a checkbox is checked?

I want calc to run one calculation if the box is checked and another if it is not. I know checkboxes can be inserted but I don’t know how to use them or if they can be used as I describe.

If it’s easy to do I’d like to try it but if this is complicated please do not feel the need to explain the process. I casn probably find another way to handle the situation.

Thanks.

Go to tab Data in control property

CheckBox.png