| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas based on form answers (yes, no checkboxes)
You can rightclick on each checkbox, choose Format Control|Control tab
and assign it a cell link. Then you can use that cell link in your IF formula: =if(a1=true,"Yes","Nope") Sarah wrote: Is there a way to create a conditional, if, then formula that is dependent on the yes/no checkboxes you can create with the form toolbar? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Form Checkboxes are not maintaining cell link | Excel Discussion (Misc queries) | |||
| I have a problem with conditional formulas based on a time period | Excel Worksheet Functions | |||
| conditional formulas based on a time period | Excel Worksheet Functions | |||
| Sum Based on Checkboxes | Excel Discussion (Misc queries) | |||
| how do i create form of yes/no answers for mass e-mail sending | Excel Worksheet Functions | |||
Threaded Mode
