I want to return a value based on the status of a check box. If .

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 <3DB85948-518B-471D-8146-05F75AAE4140@microsoft.com>,
"JROD" <JROD@discussions.microsoft.com> 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