Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas based on form answers (yes, no checkboxes)
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas based on form answers (yes, no checkboxes)
If you link the checkbox to a cell, you can just test that cell.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sarah" wrote in message ... 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? |
#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 |
Reply |
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 |