Forum Discussion
Changing True/False Result in a linked checkbox cell - Excel 2013
I am trying to change the default True/False responses to a linked checkbox in excel to something else, how do I go about that? I also don't want to use a formula, as I want to be able to edit the linked cell.
Thanks!
10 Replies
angiekish121 Not sure that what you ask for makes sense. A check box is either ticked (on), unticked (off) or mixed. Hence, TRUE (=1), FALSE (=0) or #N/A (mixed). Overwriting the linked cell with anything other than TRUE, FALSE, #N/A, 1 or 0 will untick the box.
So, what exactly is it that you want to achieve? Please give and example.
Riny_van_Eekelen I want to change the word 'True' to say something else, and be able to edit the cell (Ex. Associate ________________ was late on ________, he/she was scheduled at ______ and didn't arrive until ________)
angiekish121 If I understand correctly, you would want a checkbox for every (or perhaps only one) gap in your sentence. Correct?
If a box is checked, the linked cell becomes TRUE. You can hide it and still create a formula like:
="Hello, you were"&IF(B6, " 5 minutes late", " not late").... where B6 would be the linked cell. If TRUE, it will say "Hello, you were 5 minutes late", otherwise it will say "Hello, you were not late". Is this anywhere near to what you had in mind?
