Check Box in Excel

L

lincw

Hi all,

I'm trying to create a check box for the user to check on or off.

When it is off, the value of cell (c1) should be zero. When it is checked
the value of cell (c1) should be derived from a formula (a1+a2+b1)

How can I accomplish this? I don't need to use a check box, as long as
there is a way for the user to easily turn it off and on.

Thanks
Lincoln
 
L

lincw

It worked... I didn't know it could've been done with an If statement.

Thanks, Sune.
 
Top