How do you assess the state of a form-checkbox in a logic statemen

  • Thread starter Thread starter jvatlanta
  • Start date Start date
J

jvatlanta

Can anyone give an example of accessing the logic state of a form-checkbox
(true-false) for use in an IF statement?
 
Whatever cell the checkbox is linked to can be used in your IF statement.

If the checkbox is tied to say cell a1, in another cell if you put
"=if(a1=true,"Happy","Sad")" (without quotes) as you check and uncheck the
box the other cell will change from Happy to Sad.

Squeaky
 
Back
Top