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

L

Lady_snap

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
 
D

Dave F

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
 
T

Teethless mama

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...")
 
Top