Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 , "JROD" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to return a value based on a whether a number is within a ra. | Excel Worksheet Functions | |||
I want to return "0" based on another cell | Excel Worksheet Functions | |||
formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |