IF formula question

  • Thread starter Thread starter Mike M.
  • Start date Start date
M

Mike M.

When using a checkbox, is it possible to write an "IF" formula in another
cell that returns a value if the check box is clicked.
For instance (the check box is in cell C1), I would like the formula to read
something like =IF(C1="True",B1," ").
Thanks,
 
If your checkbox is from the Forms toolbar, you can right-click the
checkbox, choose Format Control, and enter C1 in the Cell Link box.
Then C1 will contain TRUE if the checkbox is checked, FALSE if it's
unchecked (you can change the formatting if you don't want to see
the TRUE/FALSE: Format/Cells/Number/Custom ;;;)

Then you can use

=IF(C1,B1,"")
 
Back
Top