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.

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.