[Wolfgang Gary]

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

[macropod]

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

[Wolfgang Gary]

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

[macropod]

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

[Graham Mayor]

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

[Peter Jamieson]

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

[Wolfgang Gary]

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