Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
True/False Checkboxes
I've been searching unsuccesfully for an answer to this question for
the past three days. I'm a complete beginner with Excel so please excuse my ignorance... I'm trying to make a simple checkbox in my spreadsheet so that when it is checked the value = TRUE and when it is blank the value = FALSE. ie. Cell A1 has a checkbox and I want to reference cell A1 in cell B2. So if A1 is checked and the value is true than B2 would change to 100 and if it is false it would stay at 200. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
True/False Checkboxes
Link the checkbox to A1 and in B2 put the formula
=if(A1,100,200) -- Regards, Tom Ogilvy "dankim" wrote in message om... I've been searching unsuccesfully for an answer to this question for the past three days. I'm a complete beginner with Excel so please excuse my ignorance... I'm trying to make a simple checkbox in my spreadsheet so that when it is checked the value = TRUE and when it is blank the value = FALSE. ie. Cell A1 has a checkbox and I want to reference cell A1 in cell B2. So if A1 is checked and the value is true than B2 would change to 100 and if it is false it would stay at 200. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
TRUE/FALSE from checkboxes | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
True Or False, no matter what... it still displays the false statement | Excel Programming | |||
Convert True/False to checkboxes | Excel Programming |