A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

IF statement using checkboxes



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 27th, 2004, 05:14 PM
Janice
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.