Check Box in Excel

  • Thread starter Thread starter lincw
  • Start date Start date
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
 
It worked... I didn't know it could've been done with an If statement.

Thanks, Sune.
 
lincw said:
It worked... I didn't know it could've been done with an If statement.

Thanks, Sune.
Click to expand...

You'r welcome. Thanks for the feed-back.

/Sune
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
somewhat complicated conditional formula 2
making cells uncopyable 1
Tick or Toggle 6
LOOKUP function different? 2
Countif function giving incorrect answer 5
Find the rightmost value 5
Drop-down list and error message 1

Back
Top