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
|