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?

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?

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