| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Boxes
Can anyone tell me if this is possible. I want the text in cell A1 to appear
in cell A2 only if the check box in cell A3 is checked. If this is possible, can you tell me how to do it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Boxes
If you use a linked cell for that checkbox, you can check it in your formula.
For instance, if A3 is the linked cell for the checkbox hovering over A3, this formula would go in A2: =if(a3=true,a1,"") or =if(a3<true,"",a1) Or if A1 can be empty: =if(a3<true,"",if(a1="","",a1)) (to stop 0 from showing up when A1 is empty) Joe wrote: Can anyone tell me if this is possible. I want the text in cell A1 to appear in cell A2 only if the check box in cell A3 is checked. If this is possible, can you tell me how to do it? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Boxes
Thank you very, very much. I will give it a try.
"Dave Peterson" wrote: If you use a linked cell for that checkbox, you can check it in your formula. For instance, if A3 is the linked cell for the checkbox hovering over A3, this formula would go in A2: =if(a3=true,a1,"") or =if(a3<true,"",a1) Or if A1 can be empty: =if(a3<true,"",if(a1="","",a1)) (to stop 0 from showing up when A1 is empty) Joe wrote: Can anyone tell me if this is possible. I want the text in cell A1 to appear in cell A2 only if the check box in cell A3 is checked. If this is possible, can you tell me how to do it? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| Check Boxes | Excel Worksheet Functions | |||
| Check Boxes | Excel Discussion (Misc queries) | |||
Linear Mode
