Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
I want to make following IF-Statement:
IF (PMTest_Ergebnis=71 AND PMTest_Ergebnis75 AND FallBsp_Ergebnis=80) THEN "OK" ELSE "Not passed" I havnt found a solution with {if ..} Statements which will work. thanks for your support & any tipp best regards Wolfgang |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
Hi Wolfgang
To see how to do this and a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Testing Or Returning Text Strings With Logical Functions In Bookmarks' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Wolfgang Gary" wrote in message ... I want to make following IF-Statement: IF (PMTest_Ergebnis=71 AND PMTest_Ergebnis75 AND FallBsp_Ergebnis=80) THEN "OK" ELSE "Not passed" I havnt found a solution with {if ..} Statements which will work. thanks for your support & any tipp best regards Wolfgang |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
thanks for your tipp, but its not working.
To check only one mergefield is working fine: {if {mergefield PM_TEST_RESULT}="80" "OK" "not passed"} But how to achieve logical ADD for two or more fields? {if ({mergefield PM_TEST_RESULT}="80")*({mergefield FALLSTUDIE_RESULT}="80") "OK" "not passed"} is not working. Thanks for any tipp best regards Wolfgang |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
Hi Wolfgang,
Try: {IF{if {mergefield PM_TEST_RESULT}= 80 1 0}*{IF{mergefield FALLSTUDIE_RESULT}= 80 1 0}= 1 "OK" "not passed"} } Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Wolfgang Gary" wrote in message ... thanks for your tipp, but its not working. To check only one mergefield is working fine: {if {mergefield PM_TEST_RESULT}="80" "OK" "not passed"} But how to achieve logical ADD for two or more fields? {if ({mergefield PM_TEST_RESULT}="80")*({mergefield FALLSTUDIE_RESULT}="80") "OK" "not passed"} is not working. Thanks for any tipp best regards Wolfgang |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
Your syntax is wrong - see Macropod's reply and notice especially the shape
of the brackets. The curly {}field boundary brackets are all inserted with CTRL+F9. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Wolfgang Gary wrote: thanks for your tipp, but its not working. To check only one mergefield is working fine: {if {mergefield PM_TEST_RESULT}="80" "OK" "not passed"} But how to achieve logical ADD for two or more fields? {if ({mergefield PM_TEST_RESULT}="80")*({mergefield FALLSTUDIE_RESULT}="80") "OK" "not passed"} is not working. Thanks for any tipp best regards Wolfgang |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
Either
{ IF { ={ IF { mergefield PM_TEST_RESULT } = 80 1 0}*{ IF { mergefield FALLSTUDIE_RESULT }= 80 1 0 } = 1 } "OK" "not passed" } or { IF { ={ COMPARE { mergefield PM_TEST_RESULT } = 80 }*{ COMPARE { mergefield FALLSTUDIE_RESULT }= 80 } = 1 } "OK" "not passed" } All the {} need to be the special field code braces that you can insert using ctrl-F9 Peter Jamieson "Wolfgang Gary" wrote in message ... thanks for your tipp, but its not working. To check only one mergefield is working fine: {if {mergefield PM_TEST_RESULT}="80" "OK" "not passed"} But how to achieve logical ADD for two or more fields? {if ({mergefield PM_TEST_RESULT}="80")*({mergefield FALLSTUDIE_RESULT}="80") "OK" "not passed"} is not working. Thanks for any tipp best regards Wolfgang |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF-construct?
I have found a working solution:
{ IF { ={ IF { mergefield PM_TEST_RESULT } = "80" 1 0}*{ IF { mergefield FALLSTUDIE_RESULT }= "80" 1 0 }} = "1" "OK" "not passed" } Please note the quote in the IF expressions. thanks for your tipps Wolfgang |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I construct a manual? | New Users | |||
How can I use Bengali letters to construct Bengali words? | New Users | |||
how can I construct a hyperlink from concatenating text and merge. | Mailmerge |