| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual basic runtime error 5216, there is a printer error | Microsoft Word Help | |||
| Odd Mail Merge error | New Users | |||
| Word mail merge error | Microsoft Word Help | |||
| Access word mail merge error | Mailmerge | |||
| I get an error message about a problem with Microsoft Word | Microsoft Word Help | |||
Threaded Mode