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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Function Question 1
MATCH not working in IF statement 6
How can I test the text content of a cell 4
Add a checkbox to a spreadsheet 2
If Statement with Two Different Logical Test 16
checkbox triple state 1
Logical formatting for multiple values 1
Numerical value of logicals 4

Back
Top