| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF checkbox is checked/unchecked, Cell.value = yes/no
Hi,
this may be a very quick question... Using the Control Toolbox, I have a single checkbox on each sheet of a 56 sheet workbook. if that sheet is "completed" the checkbox is to be checked. Now i have a summary sheet that shows what sheets are "Completed" how do i write a cell function that will put yes or no depending on the true/false of the checkbox? Thanks! this is a sample of my summary sheet something like this: A B sheet1 =IF(sheet1.checkbox1, "yes", "no") sheet2 =IF(sheet2.checkbox1, "yes", "no") sheet3 =IF(sheet3.checkbox1, "yes", "no") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| Delete old data when checkbox is unchecked | Excel Discussion (Misc queries) | |||
| Delete range on another sheet when checkbox is unchecked | Excel Discussion (Misc queries) | |||
| Gridline box checked or unchecked. Gridlines do not print. | New Users to Excel | |||
| Is checkbox is checked? | Excel Discussion (Misc queries) | |||
Threaded Mode
