K
Kazoo
I am trying to change a checkbox's value based on the
condition of (2) other cells. Example..
IF A1 & B1 are NOT equal, C1 holds the value of FALSE or 0
IF A1 & B1 ARE equal, C1 holds the value of TRUE or 1
Formulas i have tried in C1
=IF(A1=B1,1,0)
=IF(A1=B1,TRUE,FALSE)
=IF(A1=B1,"TRUE","FALSE")
My checkbox has a "linked cell" of C1, which theoretically
*should* force the checkbox to a checked/non-checked
position, depending on what formula output is dumped into
C1. IT DOES NOT. It only works when i MANUALLY type a
value into C1.
Can anyone explain why, or tell me how to get this working
the way i need?
condition of (2) other cells. Example..
IF A1 & B1 are NOT equal, C1 holds the value of FALSE or 0
IF A1 & B1 ARE equal, C1 holds the value of TRUE or 1
Formulas i have tried in C1
=IF(A1=B1,1,0)
=IF(A1=B1,TRUE,FALSE)
=IF(A1=B1,"TRUE","FALSE")
My checkbox has a "linked cell" of C1, which theoretically
*should* force the checkbox to a checked/non-checked
position, depending on what formula output is dumped into
C1. IT DOES NOT. It only works when i MANUALLY type a
value into C1.
Can anyone explain why, or tell me how to get this working
the way i need?