IF formula question

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,
 
J

J.E. McGimpsey

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,"")
 
Top