IF Function & Checkboxes

  • Thread starter Thread starter CP
  • Start date Start date
C

CP

Hi All,

If I insert a checkbox or option button in a cell, how do
I use an IF Formula to tell another cell to say what the
checked box says? And leave the cell blank if it's not
checked?

Example: =IF(A1 is checked,Yes,Blank) A1 has the
checkbox with 'Yes' next to it.

When I try this, it doesn't like the
word 'checked'or 'blank'. What would be the right
terminology?

Thanks, CP
 
One way,

using the check box from the forms toolbar, right click the check box and select
format control, in the control tab in the cell link box put a cell somewhere off the visible sheet, for example IV1
now in the the cell where you want yes put this formula

=IF(IV1,"Yes","")

if you are using the checkbox from the control toolbox, after you have put the
checkbox on the sheet, right click and select properties, find the cell link and put the
cell reference there, use the same formula
 
Back
Top