View Single Post
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
macropod
 
Posts: n/a
Default Form Formula doesn't work if the result is ZERO?

Hi Angyl,

Ordinarily, you'd use a formula field coded as:
{=Emod*PremiumTotal \# $,0.00}
and, if Emod hasn't been filled in, the result of the calculation would be
$0.00

If Emod is supposed to be a loading, then usually the calculation would be
something like:
=(Emod+1)*PremiumTotal
for which you'd use a formula field coded as:
{=(Emod+1)*PremiumTotal \# $,0.00}

In both cases the field braces (ie '{ }') are created in pairs via Ctrl-F9.

Cheers


"Angyl" wrote in message
...
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!!