Under the forms toolbar, create a checkbox. Format the checkbox to have a
cell link to the correct cell. Returns TRUE/FALSE.
Then have another cell do something like:
=B2*1
to change the T/F to 1/0
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lisa" wrote:

I need cells to show values when a check mark is entered. Like if I check
this box then the value is 1.0 - this needs to be in several columns that I
can then add the values together from