Typing If Field Codes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a merge document that I'm trying to use the IF field in and I can't
seem to get it to work.

I want to say IF County = Kings, Queens or Richmond, insert 40.00

I seem to be typing the codes wrong.

Can someone help? Thanks.
 
Ryan,

{ IF County = "Kings""40.00"{If County = "Queens""40.00"{If County
="Richmond""40.00" }}}
 
Don't forget to put in the {} using CONTROL F9. I wasted a whole lot of
time one day trying to enter them manually.
 
Thanks. I tried this and I keep getting a field calculation error when I
complete the merge. Could it be the spacing? Should there be a space before
and after every bracket?

Also, I'm using ctrl + F9 to insert the brackets?

One other thing. Can you also let me know how to do and AND statement. I'm
having trouble with this as well.

I want to say If County = "Nassau" AND Plaintiff = "1" result should be "500"
 
Yeah, I found that out too. I tried that way and it still won't work. Maybe
it's something with the spacing.
 
answered in another newsgroup. Please do not multipost.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
Where is the field getting 'county' from? If it is from a bookmark you'll
need {REF County} if it is from a mailmerge, you'll need {Mergefield
County} - same applies to Plaintiff.

As for the other calculation (assuming a mailmerge) the following will enter
500 if both conditions are met, nothing if one or both are not

{IF {Mailmerge County} = "Nassau" "{IF {Mailmerge Plaintiff} = 1 "500" }}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Ok. Thank you. I got it working, however, I have another question. Is it
possible to use the IF AND statement with more than two conditions? I'd like
to use it with three or four. Thank you.

Allison
 
You have to nest them. See the "Specify multiple conditions" example in the
Help topic "Examples of IF fields."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
The help files are not helpful at all. They only show two conditions using
AND. I want to know how to do it with three or four conditions.

For example: If PleadingType = "noe" and Plaintiff = "1" and County =
"Kings" "True Text" "False Text"

Thank you.
 
Each one has to be nested one level farther. Use your imagination!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top