How can you make an 'If statement' with checkboxes?

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

Guest

I am trying to set up an 'if statement' with checkboxes. I would like it to
make it so that if the checkbox is check...such and such happens...but I
can't seem to figure this out.
Please help me out
 
The check box has to be linked to a cell, which cell will return TRUE or
FALSE, depending on whether the box is checked (TRUE) or not (FALSE). You
can use these values to build your IF statement.

To link a check box to a cell, right click on its border and navigate to the
option that allows you to link it to a cell.

Dave
 
Assuming your check box link to cell A1. If the check box is checked then A1
becomes TRUE

Formula: =IF(A1=TRUE,"such and such happens","else...")
 

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

Checkbox macros 2
How do I put a checkbox with no words? 2
Need help with excel and checkboxes 2
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
How to have Checkbox A uncheck with checked Checkbox B 3
Checkbox issue - Checkbox overlapping when filter is applied 1
Inserting a simple checkbox that can be checked 4
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS 5

Back
Top