You're seeing exactly what it means for a cell to be linked to a
checkbox - i.e., it receives the value of the checkbox.

If you want the formula in the cell, what is the purpose of the linked
checkbox?

In article ,
AMS wrote:

I am using checkboxes on a spreadsheet "linked" to other cells on that sheet
that have "IF" statements in them. If a checkbox is manually checked, the
"IF" statement in the linked cell disapears and TRUE or FALSE appears in that
cell. Is there a way I can lock or protect the linked cell?