Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
David Cahill
 
Posts: n/a
Default Auto Sum Formula Question

I have created a form with tables and form fields so that users can enter
their data by typing it in. The form can also be filled in manually.

At the bottom of the form I have a table w/ 4 colums for various fees. The
Auto Sum formula works great.

Here is the problem: 50% of the people who will use my form will simply
print it out and fill it in by hand. They will not be filling out
electronically.

When I print my form, the cells for "Total Fees" automatically populate
"$0.00". No data has been entered in the table and my guess is that the
formula thinks that "$0.00" has been input into these fields.

How do I make it so that the auto sum formula does not execute unless
someone enters data into the form fields w/in the table?
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Two Auto Corrections Kim Microsoft Word Help 0 May 2nd 06 07:03 PM
Exam question wrong about Word? Opinions, please! Jamie Furlong New Users 6 April 18th 06 11:56 AM
No Idea how to label this question - regarding auto text with docu Nick Collins Microsoft Word Help 2 April 8th 06 05:45 AM
Auto Text Question Chris Z. Microsoft Word Help 1 March 14th 06 07:36 PM
Auto Text Question Me Microsoft Word Help 2 January 27th 06 06:01 PM


All times are GMT +1. The time now is 12:00 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"