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.
--
Allison

Ryan,

{ IF County = "Kings""40.00"{If County = "Queens""40.00"{If County
="Richmond""40.00" }}}

--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

a_ryan1972 wrote:
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.

Don't forget to put in the {} using CONTROL F9. I wasted a whole lot of
time one day trying to enter them manually.

"a_ryan1972" wrote in message
...
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.
--
Allison

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"



"Greg Maxey" wrote:

Ryan,

{ IF County = "Kings""40.00"{If County = "Queens""40.00"{If County
="Richmond""40.00" }}}

--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

a_ryan1972 wrote:
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.

Yeah, I found that out too. I tried that way and it still won't work. Maybe
it's something with the spacing.

"Barb Reinhardt" wrote:

Don't forget to put in the {} using CONTROL F9. I wasted a whole lot of
time one day trying to enter them manually.

"a_ryan1972" wrote in message
...
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.
--
Allison

I tried that way too and it still doesn't seem to be working.

"Barb Reinhardt" wrote:

Don't forget to put in the {} using CONTROL F9. I wasted a whole lot of
time one day trying to enter them manually.

"a_ryan1972" wrote in message
...
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.
--
Allison

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.

"a_ryan1972" wrote in message
...
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.
--
Allison

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
Word MVP web site http://word.mvps.org



a_ryan1972 wrote:
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"



"Greg Maxey" wrote:

Ryan,

{ IF County = "Kings""40.00"{If County = "Queens""40.00"{If County
="Richmond""40.00" }}}

--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

a_ryan1972 wrote:
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.

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

"Charles Kenyon" wrote:

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.

"a_ryan1972" wrote in message
...
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.
--
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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"a_ryan1972" wrote in message
...
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

"Charles Kenyon" wrote:

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.

"a_ryan1972" wrote in message
...
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.
--
Allison

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.




"Suzanne S. Barnhill" wrote:

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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"a_ryan1972" wrote in message
...
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

"Charles Kenyon" wrote:

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.

"a_ryan1972" wrote in message
...
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.
--
Allison

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"a_ryan1972" wrote in message
...
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.




"Suzanne S. Barnhill" wrote:

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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"a_ryan1972" wrote in message
...
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

"Charles Kenyon" wrote:

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.

"a_ryan1972" wrote in message
...
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.
--
Allison