IF statement problem !Syntax Error, !

From: "jlawson" <JoshMLawson@xxxxxxxxx>
Date: 10 Jul 2006 09:39:54 -0700

I created a IF, THEN, ELSE field in word that is based on certain
fields that the user will fill in.

OPNet = $5,000
OPMet = $2,000

DedNet = $1,000
DedMet = $100

NetPer = 80%

txtEC1 = $100
txtEC2 = $2500
etc...

This is what I have but I feel I'm missing something simple in the
formula...

!Syntax Error, !

{=IF((txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6+txtEC7)>(OPNet-OPMet),(OPNet-OPMet),{
IF((txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6+txtEC7)>(DedNet-DedMet),((txtEC1+txtEC2+txtEC3+
txtEC4+txtEC5+txtEC6+txtEC7)-(DedNet-DedMet))-(((txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6+txtEC7)-(DedNet-DedMet))*NetPer)+(DedNet-DedMet),(txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6+txtEC7)
}) }

Thank you in advance!

.

Follow-Ups:
- Re: IF statement problem !Syntax Error, !
  - From: Cindy M -WordMVP-

Prev by Date: Re: Adding lines before tables
Next by Date: Re: Insert>>Cross reference... mergeformat by default??
Previous by thread: Re: Creating sequential serial numbers in Word 2003
Next by thread: Re: IF statement problem !Syntax Error, !
Index(es):
- Date
- Thread