I want to give each checkbox a value, such as 1 or .5, so when checked I can sum up values.
P Paula Mar 5, 2006 #1 I want to give each checkbox a value, such as 1 or .5, so when checked I can sum up values.
D davesexcel Mar 5, 2006 #2 Paula said: I want to give each checkbox a value, such as 1 or .5, so when checked I can sum up values. Click to expand... 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)
Paula said: I want to give each checkbox a value, such as 1 or .5, so when checked I can sum up values. Click to expand... 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)
