View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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