Excel Checkboxs, Optionbox
 

How do u chagne the value of checkbox from like true or flase to a number value

Excel Checkboxs, Optionbox
 

Hi,

There probably is an easier way, but I normally put an IF statement looking
at the referenced cell, ie


Say the check box is linked to cell A1, in B1 I would put =IF(A1=TRUE,1,2)

When the check box is checked the value returned in B1 is 1, if its False
its 2.

I would normally place the check box over the same cell of A1 and set font
in A1 to white, that way all you see is the check box and the returned valve.

Hope that helps.

"Brandon" wrote:

How do u chagne the value of checkbox from like true or flase to a number value