![]() |
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? |
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