control if statement from check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can a check box control a the flow of an if statement

See this as example

=if(checkbox1=true,Sum(A:A) ,Sum(B:B)

Is this approaching the problem the right way

Bruce
 
Add a linked cell for that checkbox.

If it's a checkbox from the Forms toolbar,
right click on it, choose format control|Control tab
Look for Cell Link

If it's a checkbox from the control toolbox toolbar,
then go into design mode
right click on it|properties|
look for linked cell.


(then use that cell link in your formula.)
 
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

Check box counting 7
Referencing set columns on multiple worksheets 2
Check Box Help 4
Loop for check boxes 4
checking if two arrays are equal 3
Check Box macro 1
Set Column choice to a variable from a Drop Down 4
Form Control vs. Active X Controls 7

Back
Top