IF statement problem !Syntax Error, !
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+tx tEC7)(OPNet-OPMet),(OPNet-OPMet),{
IF((txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6+txtE C7)(DedNet-DedMet),((txtEC1+txtEC2+txtEC3+
txtEC4+txtEC5+txtEC6+txtEC7)-(DedNet-DedMet))-(((txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6+txtEC 7)-(DedNet-DedMet))*NetPer)+(DedNet-DedMet),(txtEC1+txtEC2+txtEC3+txtEC4+txtEC5+txtEC6 +txtEC7)
}) }
Thank you in advance!
|