Re: Form Formula doesn't work if the result is ZERO?
- From: "Graham Mayor" <gmayor@xxxxxxxx>
- Date: Fri, 5 May 2006 17:33:00 +0300
I'll leave the clever mathematics to you ;)
However, it works as written.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
macropod wrote:
Hi Graham,
If Emod can only be integers (or, at least, 0 or any value >= 1) you
don't need anything more complicated than:
{=MAX(Emod,1)*PremiumTotal \# $,0.00}
Alternatively, if Emod can sometimes be between 0 and 1:
{IF{=Emod}= 0 {=PremiumTotal} {=Emod*PremiumTotal} \# $,0.00}
Cheers
"Graham Mayor" <gmayor@xxxxxxxx> wrote in message
news:%23Zi6bgAcGHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Based on the information provided, the field requires some additional
conditions:
{IF{ ={ Emod } * { PremiumTotal } } = "!Syntax*" "{ ={ PremiumTotal
} * { LLimit } }" "{ IF{ Emod } = 0 "{ ={ PremiumTotal } * { LLimit
} }" "{ ={ Emod } * { PremiumTotal } }" }" }
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Angyl wrote:
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!!
.
- References:
- Re: Form Formula doesn't work if the result is ZERO?
- From: Graham Mayor
- Re: Form Formula doesn't work if the result is ZERO?
- From: Graham Mayor
- Re: Form Formula doesn't work if the result is ZERO?
- From: macropod
- Re: Form Formula doesn't work if the result is ZERO?
- Prev by Date: Re: Word 2003 document icons not displaying
- Next by Date: Re: how to create my own personal banner
- Previous by thread: Re: Form Formula doesn't work if the result is ZERO?
- Next by thread: Re: Form Formula doesn't work if the result is ZERO?
- Index(es):
Relevant Pages
|
