Change checkbox value...

[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?

 

[Guest]

To answer my own post...
It turned out to be a formatting error...I had formatted
one cell as "text", the other as "number" therefore they
were not "equal"

Kazoo

 

[may]

Try:
=EXACT(A1,B1)