How do I set up a formula with a check box?

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

Guest

I want to set up a formula on a worksheet using a check box. I want the
formula to return a Value of "Pass" if the checkbox in the cell is checked,
otherwise, I want the formula to return a value of "Fail" if it is not
checked.
 
An actual checkmark is a pain to use - involves changing font.
If an X will do, here is a formula: =IF(A1="X","Pass", "Fail")
Excel is not case-sensitive so X or x will trigger Pass
best wishes
 
Click on Tools-Customize and then check Forms to open the Forms Toolbar.
Click on the check box icon on the Forms Toolbar and then click on the
spreadsheet where you want the check box to appear.
Right click on the check box and then click Format Control. On the Control
tab, enter a cell address where it says Cell Link. This cell address you
entered will then show TRUE if the check box is checked or FALSE if the check
box is not checked.
 
Back
Top