conditional formulas based on form answers (yes, no checkboxes)

S

Sarah

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?
 
B

Bob Phillips

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)
 
D

Dave Peterson

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")
 
Top