Change checkbox value...

  • Thread starter Thread starter Kazoo
  • Start date Start date
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?
 
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
 
Back
Top