View Single Post
  #2  
Old April 27th, 2004, 06:14 PM
mickey
external usenet poster
 
Posts: n/a
Default IF statement using checkboxes

You could do that in a macro but I do not know if possible
to do without. Sorry.
-----Original Message-----
Hello,
I have been creating forms using tables in a word
document and have used the check boxes also. What I have
been stumbling over is the same question you have but
something more simple. I would like to just add up the
check boxes in the column above. Did you resolve your
question and can you reply if you know the answer? I
can't seem to get any formula to work with the check
boxes. Please help is you know the answer. Thank you!
Janice

-----Original Message-----
I am trying to get a calculation in a field that if the
checkbox is checked calculate if not checked then leave
blank. My bookmark names for the two check boxes are
comptime and pay. They are both in the same table cell.

My
formula is {=IF(comptime) = "0" "" {IF(pay) = "0"
(g14+h14) \#"##0.00;(#,##0.00); ""}} The first and last
brackets are done with ctrl f9. I have tried multiply
combinations. If I do not use the check boxes and use a
different field then I can get it to work but not using
the boxes. Any help would be appreciated. If this is

not
a possible please notify. Thanks
.

.