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

Thanks for the help, but the code is still not working. I've put what you
suggested in and the form is still producing a Zero, keeping the rest of the
form from functioning properly. It occured to me that there might be another
way if I could get some help with an IF statement on the calculations that
rely on the Emod that say something like this:

IF (Emod) = "0.00"
(nothing's been entered)
THEN This (LTotal) = (PremiumTotal)*(LLimit)

I see that the problem is that any number multiplied by Zero is Zero which
is why the EmodTotal field is returning a ZERO. I think I just need to put a
provision in the fields that follow it that reason; if the calculation is
ZERO, then ignore it...do something else instead.

"Graham Mayor" wrote:

Perform the calculation outside a form field, using a calculation field then
trap the Syntax error e.g.

{ IF { ={ Emod } * { PremiumTotal } } = "!Syntax*" "$0.00" "{ ={ Emod } *
{ PremiumTotal } }" }

Here $0.00 is inserted in the result when Emod is empty otherwise the
calculation result is givcen.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Angyl wrote:
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!!