I want the return a value based on the status of a check box or radio button.
If checked = true then 1 else 0
I want the return a value based on the status of a check box or radio button.
If checked = true then 1 else 0
If you're using a checkbox from the Forms toolbar, right-click the
checkbox and choose Format Control...
In the control tab, enter a cell reference (e.g., Z1) in the Cell Link
field. That cell will return TRUE/FALSE. In your target cell, enter
=--Z1
which coerces the boolean TRUE/FALSE to 1/0.
In article <[email protected]>,
"JROD" <[email protected]> wrote:
> I want the return a value based on the status of a check box or radio button.
> If checked = true then 1 else 0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks