I am interesting in how I would go about creating a value for a cell
by referencing it from another cell. I know this logic doesn't work
in Excel, but it makes sense to me...

(Function connected with cell C2) IF(C21,C3=1,C3="")

If this worked then the user could also manually override the value in
C3.

If I placed the function above into the Cell C3 I loose the ability
for the user to hand-enter values into C3 without corrupting the
function.

Is this possible?

Thank you to anyone who may respond!

Greg