return value in a cell if check box is checked
 

Is there a simple way to return a value of "1" in a cell if a check box is
checked and "0" if it is not? thank you!

return value in a cell if check box is checked
 

You could use a linked cell that will return true/false. Then use a formula
that refers to that linked cell:

=--A1
(where A1 is that linked cell)

But maybe you could just use that linked cell and do what you want with
true/false.

=countif(a1:a10,true)
could be used to count the number of checkboxes (that are linked to A1:A10) that
are checked.

Knox wrote:

Is there a simple way to return a value of "1" in a cell if a check box is
checked and "0" if it is not? thank you!

--

Dave Peterson

return value in a cell if check box is checked
 

ok, that worked! thank you!

"Dave Peterson" wrote:

You could use a linked cell that will return true/false. Then use a formula
that refers to that linked cell:

=--A1
(where A1 is that linked cell)

But maybe you could just use that linked cell and do what you want with
true/false.

=countif(a1:a10,true)
could be used to count the number of checkboxes (that are linked to A1:A10) that
are checked.

Knox wrote:

Is there a simple way to return a value of "1" in a cell if a check box is
checked and "0" if it is not? thank you!

--

Dave Peterson