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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Russell-stanely" wrote in
message ...
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.