Excel CheckBox

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

Guest

I've created a checkbox in A1.
If the checkbox is checked, I want B1 to appear as 1 and if not, 2. I
cannot get my if function to work. The worksheet recongnizes A1 as an empty
cell. I tried checkbox1>"1", and got a name error message. Help.
 
You need to link the check box to a cell and it will return either TRUE or
FALSE so if it is linked to H1 you can use this in B1


=IF(H1,1,2)


You could link it to a cell that is not visible (like IV1) or hide the
column where the linked cell is
if you don't like to see TRUE or FALSE
 

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
Arrays and Checkboxes 3
Excel Excel hide/ unhide row based on checkbox 0
Auto Assign Checkboxes in Excel 2007 2
make field invisable 4
Hide/Unhide without using macros 1
Excel Prevent Save if Checkboxes values are false in excel workbook 0
I'm still having problems with my macros that need to toggle off a check box. 2

Back
Top