If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help! Nested If
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! |
#2
|
|||
|
|||
Help! Nested If
"Mickey" wrote:
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" "---"}"}"} |
Thread Tools | |
Display Modes | |
|
|