Return Value of Check Box - Word

[hahnsm]

I have a table in my Word document and I have 5 check boxes in B2 and in C2 I have inserted a formula that will return a value of 1 if Check Box 1 is checked.

My forumla is =IF(Check1=true,1,0)

I keep getting a zero for a return value even if the box is checked. Can someone help me with this error?

Thanks!

Hahnsm

 

[macropod]

Hi Hahnsm,

Unfortunately, you can't test the state of a checkbox with a field. If you don't want to use a macro, you could use a dropdown box with the options set to "0=False" and "1=True" or something such, and test those.

Cheers

[MS MVP - Word]