Help! Nested If

[Mickey]

Hi,

I am doing a mail merge using Word 2003. In my tables, I need to evaluate
the content of a field and then insert a particular character based on its
content.

For example:
If B3 <30 then enter character 74
If B3 <60 then enter character 75
If B3 <90 then enter character 76
Otherwise enter ---

I've tried various ways, but can't seem to get it. Any help would be
GREATLY appreciated!

Thanks!

 

[Jean-Guy Marcil]

Hi,

I am doing a mail merge using Word 2003. In my tables, I need to evaluate
the content of a field and then insert a particular character based on its
content.

For example:
If B3 <30 then enter character 74
If B3 <60 then enter character 75
If B3 <90 then enter character 76
Otherwise enter ---

I've tried various ways, but can't seem to get it. Any help would be
GREATLY appreciated!

Nested IF fields work according to the following basic principle:

{IF Condition 1 "Result if 1 is true" "{IF Condition2 "Result if
condition 2 is true" "Result if neither 1 or 2 is true"}"}

Of course, there are a great many variations, but this is the basic
principle, which works in most cases, including yours. So, what you need is
something like:

{IF {MERGEFIELD So_and_So} < 30 "74" "{IF {MERGEFIELD So_and_So} < 60
"75" "{IF {MERGEFIELD So_and_So} < 90 "76" "---"}"}"}