How can you make an 'If statement' with checkboxes?
 

I am trying to set up an 'if statement' with checkboxes. I would like it to
make it so that if the checkbox is check...such and such happens...but I
can't seem to figure this out.
Please help me out

How can you make an 'If statement' with checkboxes?
 

The check box has to be linked to a cell, which cell will return TRUE or
FALSE, depending on whether the box is checked (TRUE) or not (FALSE). You
can use these values to build your IF statement.

To link a check box to a cell, right click on its border and navigate to the
option that allows you to link it to a cell.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Lady_snap" wrote:

I am trying to set up an 'if statement' with checkboxes. I would like it to
make it so that if the checkbox is check...such and such happens...but I
can't seem to figure this out.
Please help me out

How can you make an 'If statement' with checkboxes?
 

Assuming your check box link to cell A1. If the check box is checked then A1
becomes TRUE

Formula: =IF(A1=TRUE,"such and such happens","else...")



"Dave F" wrote:

The check box has to be linked to a cell, which cell will return TRUE or
FALSE, depending on whether the box is checked (TRUE) or not (FALSE). You
can use these values to build your IF statement.

To link a check box to a cell, right click on its border and navigate to the
option that allows you to link it to a cell.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Lady_snap" wrote:

I am trying to set up an 'if statement' with checkboxes. I would like it to
make it so that if the checkbox is check...such and such happens...but I
can't seem to figure this out.
Please help me out