IF-construct?

[Wolfgang Gary]

I want to make following IF-Statement:

IF (PMTest_Ergebnis>=71 AND PMTest_Ergebnis<75 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/showthreaded.pl?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

 

[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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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]

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