Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Angyl
 
Posts: n/a
Default Form Formula doesn't work if the result is ZERO?

I'm building a form in Word 2003 and adding code to the bookmarked fields to
perform calculations One example would be:

=(Gross1)*(Rate1)/100

The problem I'm having is that the latter part of the form towards the total
builds upon previous calculations and all seems to come to screeching halt
(the form doesn't tally) if the result of any of the previous sections is
ZERO or a Non Entry.

Specifically my problem is that one formula does this:

=(Emod)*(PremiumTotal)

But sometimes there IS no Emod so it is ZERO. If that is the case that
field shows ZERO (but there is a number in PremiumTotal)

With the resulting ZERO in that field, I can't finish the rest of my form.

Help!!


 
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
Word Form Fields - Can you Export to Excel Spreadsheet? elfmajesty Microsoft Word Help 11 April 18th 06 02:38 PM
Form for work; never done jjsevdt Microsoft Word Help 2 August 23rd 05 10:28 PM
macrobuttons and protected document saland1 Microsoft Word Help 10 May 24th 05 02:39 PM
macro doesn't work when I unprotect form mary Formatting Long Documents 1 May 3rd 05 07:35 PM
How do I get a formula "=SUM(ABOVE)" to work in a protected WORD . Monica Microsoft Word Help 1 February 22nd 05 04:42 PM


All times are GMT +1. The time now is 09:14 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"