If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF statement using checkboxes
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 . |
Thread Tools | |
Display Modes | |
|
|