| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct formula too long, & how to use make an 'OR' statement w | Excel Worksheet Functions | |||
| Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) | |||
| How do I make a column of checkboxes quickly? | Excel Discussion (Misc queries) | |||
| How can i make this work within an IF statement: (41<=Cell<=46) | New Users to Excel | |||
| How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions | |||
Hybrid Mode
