I've created a checkbox in A1.
If the checkbox is checked, I want B1 to appear as 1 and if not, 2. I
cannot get my if function to work. The worksheet recongnizes A1 as an empty
cell. I tried checkbox1"1", and got a name error message. Help.