ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you assess the state of a form-checkbox in a logic statemen (https://www.excelbanter.com/excel-worksheet-functions/238882-how-do-you-assess-state-form-checkbox-logic-statemen.html)

jvatlanta

How do you assess the state of a form-checkbox in a logic statemen
 
Can anyone give an example of accessing the logic state of a form-checkbox
(true-false) for use in an IF statement?

Squeaky

How do you assess the state of a form-checkbox in a logic statemen
 
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

"jvatlanta" wrote:

Can anyone give an example of accessing the logic state of a form-checkbox
(true-false) for use in an IF statement?



All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com