How do I give a checked checkbox a value in excel(as .5)?
 

I want to give each checkbox a value, such as 1 or .5, so when checked I can
sum up values.

How do I give a checked checkbox a value in excel(as .5)?
 

Paula Wrote:
I want to give each checkbox a value, such as 1 or .5, so when checked I
can
sum up values.
when you get a checkbox from the forms toolbar and right click on and
select format controls.
at cell link select a cell
when you have the checkbox check or unchecked you will get a true or
false,
place is another cell
=if('yourcell'=true, 1,.5)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519193